--
INSERT INTO `app_config` (`id`, `profile_permissions_id`, `date_format`, `datetime_format`, `time_format`, `excel_currency_format`, `currency_prefix`, `vat_percentage`, `source_email_address`, `source_mobile_address`, `admin_email_address`, `sms_new_pin`, `sms_customer_valuation`, `price_guide_open_days`, `price_guide_completion_days`, `auction_max_days`, `app_version`) VALUES
-(1, 9, 'Y-m-d', 'Y-m-d H:i:s', 'H:i:s', 'R #,##0.00;[red]R -#,##0.00', 'R ', '14.00', 'noreply@bid4cars.co.za', '', 'andre@nirph.com', 1, 0, 3, 30, NULL, '1.00');
+(1, 9, 'Y-m-d', 'Y-m-d H:i:s', 'H:i:s', 'R #,##0.00;[red]R -#,##0.00', 'R ', '14.00', 'noreply@bid4cars.com.na', '', 'andre@nirph.com', 1, 0, 3, 30, NULL, '1.00');
-- --------------------------------------------------------
INSERT INTO `lib_contact` (`id`, `first_name`, `family_name`, `mobile`, `office`, `fax`, `email`, `archived`) VALUES
(1, 'Jack', 'Trader', '+27821234567', '+27111234567', NULL, 'a@imperial.com', 0),
-(2, 'Dave', 'Thomas', '+27833248462', '+27123248462', NULL, 'dave@bid4cars.co.za', 0),
+(2, 'Dave', 'Thomas', '+27833248462', '+27123248462', NULL, 'dave@bid4cars.com.na', 0),
(3, 'Byron', 'Stephenson', '+27826039258', '+27126039258', NULL, 'bstephenson@cargomotors.co.za', 0);
-- --------------------------------------------------------
--
INSERT INTO `lib_template` (`id`, `lib_repeater_template_id`, `name`, `subject`, `tags`, `email_template`, `sms_template`) VALUES
-(1, NULL, 'auction-no-sale', 'No winner on Bid4Cars Auction.', 'firstName,familyName,vehicle', '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"\r\n "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">\r\n<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">\r\n<head>\r\n <meta http-equiv="Content-type" content="text/html; charset=utf-8" />\r\n <title></title>\r\n</head>\r\n<body style="padding:0;margin:0;">\r\n <!-- Begin 100% Wrapping Table -->\r\n <table border="0" cellspacing="0" cellpadding="0" width="100%" align="center" style="margin:0; padding:0;border-collapse:collapse; border-spacing:0;width:100%;">\r\n <tr>\r\n <td style="padding:20px 0;">\r\n <!-- Begin Main Template Table --> \r\n <table border="0" cellspacing="0" cellpadding="0" width="800" align="center" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px; margin:0 auto; line-height:1.33;">\r\n <tr>\r\n <td>\r\n <img src="http://{APP_HOST}/images/EmailHeader.png" width="800" height="100" alt="Please set images to always display for our emails" style="display:block;" />\r\n </td>\r\n </tr> \r\n <tr>\r\n <td style="background:#f6f6f6;padding:20px 0">\r\n <!-- Main Content table -->\r\n <table border="0" cellspacing="0" cellpadding="0" width="800" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <tr>\r\n <!-- Spacing Column -->\r\n <td width="20" valign="top" style="width:20px;"> </td>\r\n <!-- Main Column -->\r\n <td width="420" valign="top" style="width:420px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <h1 style="font-size:18px;margin:0 0 0.5em;padding:0;font-weight:400;">No winner on Bid4Cars Auction</h1>\r\n <p style="margin:0 0 1em;padding:0;">\r\n \r\n </p>\r\n <p style="margin:0 0 1em;padding:0;">\r\n Dear [first_name] [family_name],\r\n </p>\r\n <p style="margin:0 0 1em;padding:0;">\r\n Unfortunately there were no bids on the following vehicle you loaded on Bid4Cars: [vehicle]\r\n </p>\r\n <p style="margin:0 0 1em;padding:0;">\r\n We encourage you to relist the vehicle (and amend details as required).\r\n </p>\r\n <p style="margin:0 0 1em;padding:0;">\r\n Regards,<br/>\r\n The Bid4Cars Team\r\n </p>\r\n </td>\r\n <!-- Spacing Column -->\r\n <td width="40" valign="top" style="width:40px;"> </td>\r\n <!-- Side Column -->\r\n <td width="300" valign="top" style="width:300px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <img src="http://{APP_HOST}/images/hammer.gif" width="300px" alt="Content Image" align="left" style="padding:5px;" />\r\n <h2 style="font-size:18px;margin:20px 3px 0px;padding:0;font-weight:400;">Auctions</h2>\r\n <p style="margin:0 0 1em;padding:5px;">\r\n Online technology bringing buyers and sellers\r\n together through the Dealer Network.\r\n </p> \r\n </td>\r\n <!-- Spacing Column -->\r\n <td width="20" valign="top" style="width:20px;"> </td>\r\n </tr>\r\n </table>\r\n <!-- /Main Content Table --> \r\n </td> \r\n </tr>\r\n <tr>\r\n <td style="background:#ececec;padding:10px 0 0;">\r\n <!-- Begin Footer table -->\r\n <table border="0" cellspacing="0" cellpadding="0" width="600" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:600px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <tr>\r\n <!-- Spacing Column -->\r\n <td width="20" valign="top" style="width:20px;"> </td>\r\n <!-- Main Column -->\r\n <td width="560" valign="top" style="width:560px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <p style="margin:0 0 1em;padding:0;"><b>bid4cars.co.za</b></p>\r\n </td>\r\n <!-- Spacing Column --> \r\n <td width="20" valign="top" style="width:20px;"> </td>\r\n </tr>\r\n </table>\r\n <!-- /End Footer Table --> \r\n </td>\r\n </tr> \r\n </table>\r\n <!-- /End Main Template Table -->\r\n </td>\r\n </tr>\r\n </table>\r\n<!-- /End 100% Wrapping Table --> \r\n</body>\r\n</html>\r\n', ''),
-(2, NULL, 'auction-sale-admin', 'Auction Successful.', 'vehicle,seller,price,buyer', '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"\r\n "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">\r\n<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">\r\n<head>\r\n <meta http-equiv="Content-type" content="text/html; charset=utf-8" />\r\n <title></title>\r\n</head>\r\n<body style="padding:0;margin:0;">\r\n <!-- Begin 100% Wrapping Table -->\r\n <table border="0" cellspacing="0" cellpadding="0" width="100%" align="center" style="margin:0; padding:0;border-collapse:collapse; border-spacing:0;width:100%;">\r\n <tr>\r\n <td style="padding:20px 0;">\r\n <!-- Begin Main Template Table --> \r\n <table border="0" cellspacing="0" cellpadding="0" width="800" align="center" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px; margin:0 auto; line-height:1.33;">\r\n <tr>\r\n <td>\r\n <img src="http://{APP_HOST}/images/EmailHeader.png" width="800" height="100" alt="Please set images to always display for our emails" style="display:block;" />\r\n </td>\r\n </tr> \r\n <tr>\r\n <td style="background:#f6f6f6;padding:20px 0">\r\n <!-- Main Content table -->\r\n <table border="0" cellspacing="0" cellpadding="0" width="800" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <tr>\r\n <!-- Spacing Column -->\r\n <td width="20" valign="top" style="width:20px;"> </td>\r\n <!-- Main Column -->\r\n <td width="420" valign="top" style="width:420px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <h1 style="font-size:18px;margin:0 0 0.5em;padding:0;font-weight:400;">Auction Successful</h1>\r\n <p style="margin:0 0 1em;padding:0;">\r\n \r\n </p>\r\n <p style="margin:0 0 1em;padding:0;">\r\n The auction for [vehicle] from [seller] finished with a winning bid of [price] from [buyer].\r\n </p>\r\n </td>\r\n <!-- Spacing Column -->\r\n <td width="40" valign="top" style="width:40px;"> </td>\r\n <!-- Side Column -->\r\n <td width="300" valign="top" style="width:300px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <img src="http://{APP_HOST}/images/hammer.gif" width="300px" alt="Content Image" align="left" style="padding:5px;" />\r\n <h2 style="font-size:18px;margin:20px 3px 0px;padding:0;font-weight:400;">Auctions</h2>\r\n <p style="margin:0 0 1em;padding:5px;">\r\n Online technology bringing buyers and sellers\r\n together through the Dealer Network.\r\n </p> \r\n </td>\r\n <!-- Spacing Column -->\r\n <td width="20" valign="top" style="width:20px;"> </td>\r\n </tr>\r\n </table>\r\n <!-- /Main Content Table --> \r\n </td> \r\n </tr>\r\n <tr>\r\n <td style="background:#ececec;padding:10px 0 0;">\r\n <!-- Begin Footer table -->\r\n <table border="0" cellspacing="0" cellpadding="0" width="600" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:600px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <tr>\r\n <!-- Spacing Column -->\r\n <td width="20" valign="top" style="width:20px;"> </td>\r\n <!-- Main Column -->\r\n <td width="560" valign="top" style="width:560px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <p style="margin:0 0 1em;padding:0;"><b>bid4cars.co.za</b></p>\r\n </td>\r\n <!-- Spacing Column --> \r\n <td width="20" valign="top" style="width:20px;"> </td>\r\n </tr>\r\n </table>\r\n <!-- /End Footer Table --> \r\n </td>\r\n </tr> \r\n </table>\r\n <!-- /End Main Template Table -->\r\n </td>\r\n </tr>\r\n </table>\r\n<!-- /End 100% Wrapping Table --> \r\n</body>\r\n</html>\r\n', ''),
-(3, NULL, 'auction-sale-buyer', 'Bid Successful.', 'firstName,familyName,vehicle,seller,price,seller_name,vehicle_address,seller_billing_address,seller_vat_number,seller_email', '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"\r\n "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">\r\n<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">\r\n<head>\r\n <meta http-equiv="Content-type" content="text/html; charset=utf-8" />\r\n <title></title>\r\n</head>\r\n<body style="padding:0;margin:0;">\r\n <!-- Begin 100% Wrapping Table -->\r\n <table border="0" cellspacing="0" cellpadding="0" width="100%" align="center" style="margin:0; padding:0;border-collapse:collapse; border-spacing:0;width:100%;">\r\n <tr>\r\n <td style="padding:20px 0;">\r\n <!-- Begin Main Template Table --> \r\n <table border="0" cellspacing="0" cellpadding="0" width="800" align="center" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px; margin:0 auto; line-height:1.33;">\r\n <tr>\r\n <td>\r\n <img src="http://{APP_HOST}/images/EmailHeader.png" width="800" height="100" alt="Please set images to always display for our emails" style="display:block;" />\r\n </td>\r\n </tr> \r\n <tr>\r\n <td style="background:#f6f6f6;padding:20px 0">\r\n <!-- Main Content table -->\r\n <table border="0" cellspacing="0" cellpadding="0" width="800" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <tr>\r\n <!-- Spacing Column -->\r\n <td width="20" valign="top" style="width:20px;"> </td>\r\n <!-- Main Column -->\r\n <td width="420" valign="top" style="width:420px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <h1 style="font-size:18px;margin:0 0 0.5em;padding:0;font-weight:400;">Bid Successful</h1>\r\n <p style="margin:0 0 1em;padding:0;">\r\n \r\n </p>\r\n <p style="margin:0 0 1em;padding:0;">\r\n Dear [first_name] [family_name],\r\n </p>\r\n <p style="margin:0 0 1em;padding:0;">\r\n Congratulations! You are the winning bidder of [vehicle] from [seller], at [price].\r\n </p>\r\n <p style="margin:0 0 1em;padding:0;">\r\n <b>Your responsibilities:</b>\r\n <ul>\r\n <li>Complete sale within two working days.</li>\r\n <li>Collect vehicle.</li>\r\n <li>Sign attachments when collecting vehicle.</li>\r\n </ul>\r\n </p>\r\n <p style="margin:0 0 1em;padding:0;">\r\n <b>Seller:</b>\r\n <table border="0" cellspacing="0" cellpadding="3px" width="420" style="border-collapse:collapse; border-spacing:0; margin:0; padding:3px; width:420px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <tr>\r\n <td width="80px"><b>Trading Name:</b></td>\r\n <td><b>[seller]</b></td>\r\n </tr>\r\n <tr>\r\n <td width="80px"><b>Full Name:</b></td>\r\n <td><b>[seller_name]</b></td>\r\n </tr>\r\n <tr>\r\n <td width="80px"><b>Auction Address:</b></td>\r\n <td><b>[vehicle_address]</b></td>\r\n </tr>\r\n <tr>\r\n <td width="80px"><b>Billing Address:</b></td>\r\n <td><b>[seller_billing_address]</b></td>\r\n </tr>\r\n <tr>\r\n <td width="80px"><b>VAT Number:</b></td>\r\n <td><b>[seller_vat_number]</b></td>\r\n </tr>\r\n <tr>\r\n <td width="80px"><b>E-mail:</b></td>\r\n <td><b>[seller_email]</b></td>\r\n </tr>\r\n </table>\r\n </p>\r\n <p style="margin:0 0 1em;padding:0;"><br/>\r\n Regards,<br/>\r\n The Bid4Cars Team\r\n </p>\r\n </td>\r\n <!-- Spacing Column -->\r\n <td width="40" valign="top" style="width:40px;"> </td>\r\n <!-- Side Column -->\r\n <td width="300" valign="top" style="width:300px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <img src="http://{APP_HOST}/images/hammer.gif" width="300px" alt="Content Image" align="left" style="padding:5px;" />\r\n <h2 style="font-size:18px;margin:20px 3px 0px;padding:0;font-weight:400;">Auctions</h2>\r\n <p style="margin:0 0 1em;padding:5px;">\r\n Online technology bringing buyers and sellers\r\n together through the Dealer Network.\r\n </p> \r\n </td>\r\n <!-- Spacing Column -->\r\n <td width="20" valign="top" style="width:20px;"> </td>\r\n </tr>\r\n </table>\r\n <!-- /Main Content Table --> \r\n </td> \r\n </tr>\r\n <tr>\r\n <td style="background:#ececec;padding:10px 0 0;">\r\n <!-- Begin Footer table -->\r\n <table border="0" cellspacing="0" cellpadding="0" width="600" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:600px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <tr>\r\n <!-- Spacing Column -->\r\n <td width="20" valign="top" style="width:20px;"> </td>\r\n <!-- Main Column -->\r\n <td width="560" valign="top" style="width:560px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <p style="margin:0 0 1em;padding:0;"><b>bid4cars.co.za</b></p>\r\n </td>\r\n <!-- Spacing Column --> \r\n <td width="20" valign="top" style="width:20px;"> </td>\r\n </tr>\r\n </table>\r\n <!-- /End Footer Table --> \r\n </td>\r\n </tr> \r\n </table>\r\n <!-- /End Main Template Table -->\r\n </td>\r\n </tr>\r\n </table>\r\n<!-- /End 100% Wrapping Table --> \r\n</body>\r\n</html>\r\n', 'Congratulations! You have won [vehicle] on Bid4Cars for [price]. Please check your e-mail for more info.'),
-(4, NULL, 'auction-sale-seller', 'Auction Successul.', 'firstName,familyName,vehicle,price,buyer,buyer_name,buyer_address,buyer_vat_number,buyer_mobile,buyer_email', '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"\r\n "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">\r\n<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">\r\n<head>\r\n <meta http-equiv="Content-type" content="text/html; charset=utf-8" />\r\n <title></title>\r\n</head>\r\n<body style="padding:0;margin:0;">\r\n <!-- Begin 100% Wrapping Table -->\r\n <table border="0" cellspacing="0" cellpadding="0" width="100%" align="center" style="margin:0; padding:0;border-collapse:collapse; border-spacing:0;width:100%;">\r\n <tr>\r\n <td style="padding:20px 0;">\r\n <!-- Begin Main Template Table --> \r\n <table border="0" cellspacing="0" cellpadding="0" width="800" align="center" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px; margin:0 auto; line-height:1.33;">\r\n <tr>\r\n <td>\r\n <img src="http://{APP_HOST}/images/EmailHeader.png" width="800" height="100" alt="Please set images to always display for our emails" style="display:block;" />\r\n </td>\r\n </tr> \r\n <tr>\r\n <td style="background:#f6f6f6;padding:20px 0">\r\n <!-- Main Content table -->\r\n <table border="0" cellspacing="0" cellpadding="0" width="800" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <tr>\r\n <!-- Spacing Column -->\r\n <td width="20" valign="top" style="width:20px;"> </td>\r\n <!-- Main Column -->\r\n <td width="420" valign="top" style="width:420px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <h1 style="font-size:18px;margin:0 0 0.5em;padding:0;font-weight:400;">Auction Successful</h1>\r\n <p style="margin:0 0 1em;padding:0;">\r\n \r\n </p>\r\n <p style="margin:0 0 1em;padding:0;">\r\n Hello [first_name] [family_name],\r\n </p>\r\n <p style="margin:0 0 1em;padding:0;">\r\n Congratulations! Your vehicle [vehicle] finished with a winning bid of [price] from [buyer].\r\n </p>\r\n <p style="margin:0 0 1em;padding:0;">\r\n <b>Your responsibilities:</b>\r\n <ul>\r\n <li>Invoice vehicle.</li>\r\n <li>Send Natis, invoice and bank details.</li>\r\n <li>Have vehicle ready for collection.</li>\r\n <li>Print attachments.</li>\r\n </ul>\r\n </p>\r\n <p style="margin:0 0 1em;padding:0;">\r\n <b>Buyer:</b>\r\n <table border="0" cellspacing="0" cellpadding="3px" width="420" style="border-collapse:collapse; border-spacing:0; margin:0; padding:3px; width:420px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <tr>\r\n <td width="80px"><b>Trading Name:</b></td>\r\n <td><b>[buyer]</b></td>\r\n </tr>\r\n <tr>\r\n <td width="80px"><b>Full Name:</b></td>\r\n <td><b>[buyer_name]</b></td>\r\n </tr>\r\n <tr>\r\n <td width="80px"><b>Physical Address:</b></td>\r\n <td><b>[buyer_address]</b></td>\r\n </tr>\r\n <tr>\r\n <td width="80px"><b>VAT Number:</b></td>\r\n <td><b>[buyer_vat_number]</b></td>\r\n </tr>\r\n <tr>\r\n <td width="80px"><b>Cellphone:</b></td>\r\n <td><b>[buyer_mobile]</b></td>\r\n </tr>\r\n <tr>\r\n <td width="80px"><b>E-mail:</b></td>\r\n <td><b>[buyer_email]</b></td>\r\n </tr>\r\n </table>\r\n </p>\r\n <p style="margin:0 0 1em;padding:0;"><br/>\r\n Regards,<br/>\r\n The Bid4Cars Team\r\n </p>\r\n </td>\r\n <!-- Spacing Column -->\r\n <td width="40" valign="top" style="width:40px;"> </td>\r\n <!-- Side Column -->\r\n <td width="300" valign="top" style="width:300px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <img src="http://{APP_HOST}/images/hammer.gif" width="300px" alt="Content Image" align="left" style="padding:5px;" />\r\n <h2 style="font-size:18px;margin:20px 3px 0px;padding:0;font-weight:400;">Auctions</h2>\r\n <p style="margin:0 0 1em;padding:5px;">\r\n Online technology bringing buyers and sellers\r\n together through the Dealer Network.\r\n </p> \r\n </td>\r\n <!-- Spacing Column -->\r\n <td width="20" valign="top" style="width:20px;"> </td>\r\n </tr>\r\n </table>\r\n <!-- /Main Content Table --> \r\n </td> \r\n </tr>\r\n <tr>\r\n <td style="background:#ececec;padding:10px 0 0;">\r\n <!-- Begin Footer table -->\r\n <table border="0" cellspacing="0" cellpadding="0" width="600" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:600px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <tr>\r\n <!-- Spacing Column -->\r\n <td width="20" valign="top" style="width:20px;"> </td>\r\n <!-- Main Column -->\r\n <td width="560" valign="top" style="width:560px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <p style="margin:0 0 1em;padding:0;"><b>bid4cars.co.za</b></p>\r\n </td>\r\n <!-- Spacing Column --> \r\n <td width="20" valign="top" style="width:20px;"> </td>\r\n </tr>\r\n </table>\r\n <!-- /End Footer Table --> \r\n </td>\r\n </tr> \r\n </table>\r\n <!-- /End Main Template Table -->\r\n </td>\r\n </tr>\r\n </table>\r\n<!-- /End 100% Wrapping Table --> \r\n</body>\r\n</html>\r\n', 'Congratulations! [vehicle] has been sold on Bid4Cars for [price]. Please check your e-mail and complete the necessary documentation.'),
-(5, NULL, 'auction-outbid', 'You have been outbid.', 'firstName,familyName,vehicle,seller,price,bid,auction_expiry_date', '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"\r\n "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">\r\n<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">\r\n<head>\r\n <meta http-equiv="Content-type" content="text/html; charset=utf-8" />\r\n <title></title>\r\n</head>\r\n<body style="padding:0;margin:0;">\r\n <!-- Begin 100% Wrapping Table -->\r\n <table border="0" cellspacing="0" cellpadding="0" width="100%" align="center" style="margin:0; padding:0;border-collapse:collapse; border-spacing:0;width:100%;">\r\n <tr>\r\n <td style="padding:20px 0;">\r\n <!-- Begin Main Template Table --> \r\n <table border="0" cellspacing="0" cellpadding="0" width="800" align="center" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px; margin:0 auto; line-height:1.33;">\r\n <tr>\r\n <td>\r\n <img src="http://{APP_HOST}/images/EmailHeader.png" width="800" height="100" alt="Please set images to always display for our emails" style="display:block;" />\r\n </td>\r\n </tr> \r\n <tr>\r\n <td style="background:#f6f6f6;padding:20px 0">\r\n <!-- Main Content table -->\r\n <table border="0" cellspacing="0" cellpadding="0" width="800" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <tr>\r\n <!-- Spacing Column -->\r\n <td width="20" valign="top" style="width:20px;"> </td>\r\n <!-- Main Column -->\r\n <td width="420" valign="top" style="width:420px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <h1 style="font-size:18px;margin:0 0 0.5em;padding:0;font-weight:400;">You have been outbid on [vehicle]</h1>\r\n <p style="margin:0 0 1em;padding:0;">\r\n \r\n </p>\r\n <p style="margin:0 0 1em;padding:0;">\r\n Dear [first_name] [family_name],\r\n </p>\r\n <p style="margin:0 0 1em;padding:0;">\r\n You have been outbid on the following vehicle: [vehicle] from [seller], next minimum bid is [price].\r\n Your bid of [bid] is no longer in the leading bid. The auction ends [auction_expiry_date].\r\n </p>\r\n <p style="margin:0 0 1em;padding:0;">\r\n Best of luck,<br/>\r\n The Bid4Cars Team\r\n </p>\r\n </td>\r\n <!-- Spacing Column -->\r\n <td width="40" valign="top" style="width:40px;"> </td>\r\n <!-- Side Column -->\r\n <td width="300" valign="top" style="width:300px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <img src="http://{APP_HOST}/images/hammer.gif" width="300px" alt="Content Image" align="left" style="padding:5px;" />\r\n <h2 style="font-size:18px;margin:20px 3px 0px;padding:0;font-weight:400;">Auctions</h2>\r\n <p style="margin:0 0 1em;padding:5px;">\r\n Online technology bringing buyers and sellers\r\n together through the Dealer Network.\r\n </p> \r\n </td>\r\n <!-- Spacing Column -->\r\n <td width="20" valign="top" style="width:20px;"> </td>\r\n </tr>\r\n </table>\r\n <!-- /Main Content Table --> \r\n </td> \r\n </tr>\r\n <tr>\r\n <td style="background:#ececec;padding:10px 0 0;">\r\n <!-- Begin Footer table -->\r\n <table border="0" cellspacing="0" cellpadding="0" width="800" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <tr>\r\n <!-- Spacing Column -->\r\n <td width="20" valign="top" style="width:20px;"> </td>\r\n <!-- Main Column -->\r\n <td width="380" valign="top" style="width:380px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <p style="margin:0 0 1em;padding:0;"><b>bid4cars.co.za</b></p>\r\n </td>\r\n <!-- Spacing Column --> \r\n <td width="380" valign="top" align="right" style="width:380px;">\r\n Click <a href="http://{APP_HOST}/unsubscribe/reminder">here</a> to unsubscribe from reminders.\r\n </td>\r\n <!-- Spacing Column -->\r\n <td width="20" valign="top" style="width:20px;"> </td>\r\n </tr>\r\n </table>\r\n <!-- /End Footer Table -->\r\n </td>\r\n </tr>\r\n </table>\r\n <!-- /End Main Template Table -->\r\n </td>\r\n </tr>\r\n </table>\r\n<!-- /End 100% Wrapping Table --> \r\n</body>\r\n</html>\r\n', 'You have been outbid on [vehicle], next minimum bid is [price]. Click here http://bid4cars.co.za/bid to continue bidding.'),
-(6, NULL, 'auction-question', 'Stock Question.', 'first_name,family_name,dealer,vehicle,question', '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"\r\n "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">\r\n<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">\r\n<head>\r\n <meta http-equiv="Content-type" content="text/html; charset=utf-8" />\r\n <title></title>\r\n</head>\r\n<body style="padding:0;margin:0;">\r\n <!-- Begin 100% Wrapping Table -->\r\n <table border="0" cellspacing="0" cellpadding="0" width="100%" align="center" style="margin:0; padding:0;border-collapse:collapse; border-spacing:0;width:100%;">\r\n <tr>\r\n <td style="padding:20px 0;">\r\n <!-- Begin Main Template Table -->\r\n <table border="0" cellspacing="0" cellpadding="0" width="800" align="center" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px; margin:0 auto; line-height:1.33;">\r\n <tr>\r\n <td>\r\n <img src="http://{APP_HOST}/images/EmailHeader.png" width="800" height="100" alt="Please set images to always display for our emails" style="display:block;" />\r\n </td>\r\n </tr>\r\n <tr>\r\n <td style="background:#f6f6f6;padding:20px 0">\r\n <!-- Main Content table -->\r\n <table border="0" cellspacing="0" cellpadding="0" width="800" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <tr>\r\n <!-- Spacing Column -->\r\n <td width="20" valign="top" style="width:20px;"> </td>\r\n <!-- Main Column -->\r\n <td width="420" valign="top" style="width:420px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <h1 style="font-size:18px;margin:0 0 0.5em;padding:0;font-weight:400;">Stock Question</h1>\r\n <p style="margin:0 0 1em;padding:0;">\r\n \r\n </p>\r\n <p style="margin:0 0 1em;padding:0;">\r\n Dear [first_name] [family_name],\r\n </p>\r\n <p style="margin:0 0 1em;padding:0;">\r\n You have a question from [dealer] concerning vehicle [vehicle].\r\n </p>\r\n <p style="margin:0 0 1em;padding:0;">\r\n <b>Question:</b> [question]\r\n </p>\r\n <p style="margin:0 0 1em;padding:0;">\r\n \r\n </p>\r\n <p style="margin:0 0 1em;padding:0;">\r\n You can reply to the question in <i>My settings</i> page.\r\n </p>\r\n <p style="margin:0 0 1em;padding:0;">\r\n Regards,<br/>\r\n The Bid4Cars Team\r\n </p>\r\n </td>\r\n <!-- Spacing Column -->\r\n <td width="40" valign="top" style="width:40px;"> </td>\r\n <!-- Side Column -->\r\n <td width="300" valign="top" style="width:300px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <img src="http://{APP_HOST}/images/waiting.gif" width="300px" alt="Content Image" align="left" style="padding:5px;" />\r\n <h2 style="font-size:18px;margin:20px 3px 0px;padding:0;font-weight:400;">Need help?</h2>\r\n <p style="margin:0 0 1em;padding:5px;">\r\n If you have any questions please feel free to contact us for assistance.\r\n </p>\r\n </td>\r\n <!-- Spacing Column -->\r\n <td width="20" valign="top" style="width:20px;"> </td>\r\n </tr>\r\n </table>\r\n <!-- /Main Content Table -->\r\n </td>\r\n </tr>\r\n <tr>\r\n <td style="background:#ececec;padding:10px 0 0;">\r\n <!-- Begin Footer table -->\r\n <table border="0" cellspacing="0" cellpadding="0" width="800" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <tr>\r\n <!-- Spacing Column -->\r\n <td width="20" valign="top" style="width:20px;"> </td>\r\n <!-- Main Column -->\r\n <td width="380" valign="top" style="width:380px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <p style="margin:0 0 1em;padding:0;"><b>bid4cars.co.za</b></p>\r\n </td>\r\n <!-- Spacing Column -->\r\n <td width="380" valign="top" align="right" style="width:380px;">\r\n \r\n </td>\r\n <!-- Spacing Column -->\r\n <td width="20" valign="top" style="width:20px;"> </td>\r\n </tr>\r\n </table>\r\n <!-- /End Footer Table -->\r\n </td>\r\n </tr>\r\n </table>\r\n <!-- /End Main Template Table -->\r\n </td>\r\n </tr>\r\n </table>\r\n<!-- /End 100% Wrapping Table -->\r\n</body>\r\n</html>\r\n', ''),
-(7, NULL, 'auction-reply', 'Stock Reply.', 'first_name,family_name,dealer,vehicle,question,reply', '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"\r\n "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">\r\n<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">\r\n<head>\r\n <meta http-equiv="Content-type" content="text/html; charset=utf-8" />\r\n <title></title>\r\n</head>\r\n<body style="padding:0;margin:0;">\r\n <!-- Begin 100% Wrapping Table -->\r\n <table border="0" cellspacing="0" cellpadding="0" width="100%" align="center" style="margin:0; padding:0;border-collapse:collapse; border-spacing:0;width:100%;">\r\n <tr>\r\n <td style="padding:20px 0;">\r\n <!-- Begin Main Template Table -->\r\n <table border="0" cellspacing="0" cellpadding="0" width="800" align="center" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px; margin:0 auto; line-height:1.33;">\r\n <tr>\r\n <td>\r\n <img src="http://{APP_HOST}/images/EmailHeader.png" width="800" height="100" alt="Please set images to always display for our emails" style="display:block;" />\r\n </td>\r\n </tr>\r\n <tr>\r\n <td style="background:#f6f6f6;padding:20px 0">\r\n <!-- Main Content table -->\r\n <table border="0" cellspacing="0" cellpadding="0" width="800" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <tr>\r\n <!-- Spacing Column -->\r\n <td width="20" valign="top" style="width:20px;"> </td>\r\n <!-- Main Column -->\r\n <td width="420" valign="top" style="width:420px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <h1 style="font-size:18px;margin:0 0 0.5em;padding:0;font-weight:400;">Stock Reply</h1>\r\n <p style="margin:0 0 1em;padding:0;">\r\n \r\n </p>\r\n <p style="margin:0 0 1em;padding:0;">\r\n Dear [first_name] [family_name],\r\n </p>\r\n <p style="margin:0 0 1em;padding:0;">\r\n Your question to [dealer] concerning vehicle [vehicle] have received a reply.\r\n </p>\r\n <p style="margin:0 0 1em;padding:0;">\r\n <b>Question:</b> [question]\r\n </p>\r\n <p style="margin:0 0 1em;padding:0;">\r\n <b>Reply:</b> [reply]\r\n </p>\r\n <p style="margin:0 0 1em;padding:0;">\r\n \r\n </p>\r\n <p style="margin:0 0 1em;padding:0;">\r\n Regards,<br/>\r\n The Bid4Cars Team\r\n </p>\r\n </td>\r\n <!-- Spacing Column -->\r\n <td width="40" valign="top" style="width:40px;"> </td>\r\n <!-- Side Column -->\r\n <td width="300" valign="top" style="width:300px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <img src="http://{APP_HOST}/images/waiting.gif" width="300px" alt="Content Image" align="left" style="padding:5px;" />\r\n <h2 style="font-size:18px;margin:20px 3px 0px;padding:0;font-weight:400;">Need help?</h2>\r\n <p style="margin:0 0 1em;padding:5px;">\r\n If you have any questions please feel free to contact us for assistance.\r\n </p>\r\n </td>\r\n <!-- Spacing Column -->\r\n <td width="20" valign="top" style="width:20px;"> </td>\r\n </tr>\r\n </table>\r\n <!-- /Main Content Table -->\r\n </td>\r\n </tr>\r\n <tr>\r\n <td style="background:#ececec;padding:10px 0 0;">\r\n <!-- Begin Footer table -->\r\n <table border="0" cellspacing="0" cellpadding="0" width="800" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <tr>\r\n <!-- Spacing Column -->\r\n <td width="20" valign="top" style="width:20px;"> </td>\r\n <!-- Main Column -->\r\n <td width="380" valign="top" style="width:380px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <p style="margin:0 0 1em;padding:0;"><b>bid4cars.co.za</b></p>\r\n </td>\r\n <!-- Spacing Column -->\r\n <td width="380" valign="top" align="right" style="width:380px;">\r\n \r\n </td>\r\n <!-- Spacing Column -->\r\n <td width="20" valign="top" style="width:20px;"> </td>\r\n </tr>\r\n </table>\r\n <!-- /End Footer Table -->\r\n </td>\r\n </tr>\r\n </table>\r\n <!-- /End Main Template Table -->\r\n </td>\r\n </tr>\r\n </table>\r\n<!-- /End 100% Wrapping Table -->\r\n</body>\r\n</html>\r\n', ''),
+(1, NULL, 'auction-no-sale', 'No winner on Bid4Cars Auction.', 'firstName,familyName,vehicle', '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"\r\n "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">\r\n<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">\r\n<head>\r\n <meta http-equiv="Content-type" content="text/html; charset=utf-8" />\r\n <title></title>\r\n</head>\r\n<body style="padding:0;margin:0;">\r\n <!-- Begin 100% Wrapping Table -->\r\n <table border="0" cellspacing="0" cellpadding="0" width="100%" align="center" style="margin:0; padding:0;border-collapse:collapse; border-spacing:0;width:100%;">\r\n <tr>\r\n <td style="padding:20px 0;">\r\n <!-- Begin Main Template Table --> \r\n <table border="0" cellspacing="0" cellpadding="0" width="800" align="center" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px; margin:0 auto; line-height:1.33;">\r\n <tr>\r\n <td>\r\n <img src="http://{APP_HOST}/images/EmailHeader.png" width="800" height="100" alt="Please set images to always display for our emails" style="display:block;" />\r\n </td>\r\n </tr> \r\n <tr>\r\n <td style="background:#f6f6f6;padding:20px 0">\r\n <!-- Main Content table -->\r\n <table border="0" cellspacing="0" cellpadding="0" width="800" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <tr>\r\n <!-- Spacing Column -->\r\n <td width="20" valign="top" style="width:20px;"> </td>\r\n <!-- Main Column -->\r\n <td width="420" valign="top" style="width:420px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <h1 style="font-size:18px;margin:0 0 0.5em;padding:0;font-weight:400;">No winner on Bid4Cars Auction</h1>\r\n <p style="margin:0 0 1em;padding:0;">\r\n \r\n </p>\r\n <p style="margin:0 0 1em;padding:0;">\r\n Dear [first_name] [family_name],\r\n </p>\r\n <p style="margin:0 0 1em;padding:0;">\r\n Unfortunately there were no bids on the following vehicle you loaded on Bid4Cars: [vehicle]\r\n </p>\r\n <p style="margin:0 0 1em;padding:0;">\r\n We encourage you to relist the vehicle (and amend details as required).\r\n </p>\r\n <p style="margin:0 0 1em;padding:0;">\r\n Regards,<br/>\r\n The Bid4Cars Team\r\n </p>\r\n </td>\r\n <!-- Spacing Column -->\r\n <td width="40" valign="top" style="width:40px;"> </td>\r\n <!-- Side Column -->\r\n <td width="300" valign="top" style="width:300px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <img src="http://{APP_HOST}/images/hammer.gif" width="300px" alt="Content Image" align="left" style="padding:5px;" />\r\n <h2 style="font-size:18px;margin:20px 3px 0px;padding:0;font-weight:400;">Auctions</h2>\r\n <p style="margin:0 0 1em;padding:5px;">\r\n Online technology bringing buyers and sellers\r\n together through the Dealer Network.\r\n </p> \r\n </td>\r\n <!-- Spacing Column -->\r\n <td width="20" valign="top" style="width:20px;"> </td>\r\n </tr>\r\n </table>\r\n <!-- /Main Content Table --> \r\n </td> \r\n </tr>\r\n <tr>\r\n <td style="background:#ececec;padding:10px 0 0;">\r\n <!-- Begin Footer table -->\r\n <table border="0" cellspacing="0" cellpadding="0" width="600" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:600px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <tr>\r\n <!-- Spacing Column -->\r\n <td width="20" valign="top" style="width:20px;"> </td>\r\n <!-- Main Column -->\r\n <td width="560" valign="top" style="width:560px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <p style="margin:0 0 1em;padding:0;"><b>bid4cars.com.na</b></p>\r\n </td>\r\n <!-- Spacing Column --> \r\n <td width="20" valign="top" style="width:20px;"> </td>\r\n </tr>\r\n </table>\r\n <!-- /End Footer Table --> \r\n </td>\r\n </tr> \r\n </table>\r\n <!-- /End Main Template Table -->\r\n </td>\r\n </tr>\r\n </table>\r\n<!-- /End 100% Wrapping Table --> \r\n</body>\r\n</html>\r\n', ''),
+(2, NULL, 'auction-sale-admin', 'Auction Successful.', 'vehicle,seller,price,buyer', '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"\r\n "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">\r\n<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">\r\n<head>\r\n <meta http-equiv="Content-type" content="text/html; charset=utf-8" />\r\n <title></title>\r\n</head>\r\n<body style="padding:0;margin:0;">\r\n <!-- Begin 100% Wrapping Table -->\r\n <table border="0" cellspacing="0" cellpadding="0" width="100%" align="center" style="margin:0; padding:0;border-collapse:collapse; border-spacing:0;width:100%;">\r\n <tr>\r\n <td style="padding:20px 0;">\r\n <!-- Begin Main Template Table --> \r\n <table border="0" cellspacing="0" cellpadding="0" width="800" align="center" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px; margin:0 auto; line-height:1.33;">\r\n <tr>\r\n <td>\r\n <img src="http://{APP_HOST}/images/EmailHeader.png" width="800" height="100" alt="Please set images to always display for our emails" style="display:block;" />\r\n </td>\r\n </tr> \r\n <tr>\r\n <td style="background:#f6f6f6;padding:20px 0">\r\n <!-- Main Content table -->\r\n <table border="0" cellspacing="0" cellpadding="0" width="800" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <tr>\r\n <!-- Spacing Column -->\r\n <td width="20" valign="top" style="width:20px;"> </td>\r\n <!-- Main Column -->\r\n <td width="420" valign="top" style="width:420px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <h1 style="font-size:18px;margin:0 0 0.5em;padding:0;font-weight:400;">Auction Successful</h1>\r\n <p style="margin:0 0 1em;padding:0;">\r\n \r\n </p>\r\n <p style="margin:0 0 1em;padding:0;">\r\n The auction for [vehicle] from [seller] finished with a winning bid of [price] from [buyer].\r\n </p>\r\n </td>\r\n <!-- Spacing Column -->\r\n <td width="40" valign="top" style="width:40px;"> </td>\r\n <!-- Side Column -->\r\n <td width="300" valign="top" style="width:300px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <img src="http://{APP_HOST}/images/hammer.gif" width="300px" alt="Content Image" align="left" style="padding:5px;" />\r\n <h2 style="font-size:18px;margin:20px 3px 0px;padding:0;font-weight:400;">Auctions</h2>\r\n <p style="margin:0 0 1em;padding:5px;">\r\n Online technology bringing buyers and sellers\r\n together through the Dealer Network.\r\n </p> \r\n </td>\r\n <!-- Spacing Column -->\r\n <td width="20" valign="top" style="width:20px;"> </td>\r\n </tr>\r\n </table>\r\n <!-- /Main Content Table --> \r\n </td> \r\n </tr>\r\n <tr>\r\n <td style="background:#ececec;padding:10px 0 0;">\r\n <!-- Begin Footer table -->\r\n <table border="0" cellspacing="0" cellpadding="0" width="600" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:600px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <tr>\r\n <!-- Spacing Column -->\r\n <td width="20" valign="top" style="width:20px;"> </td>\r\n <!-- Main Column -->\r\n <td width="560" valign="top" style="width:560px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <p style="margin:0 0 1em;padding:0;"><b>bid4cars.com.na</b></p>\r\n </td>\r\n <!-- Spacing Column --> \r\n <td width="20" valign="top" style="width:20px;"> </td>\r\n </tr>\r\n </table>\r\n <!-- /End Footer Table --> \r\n </td>\r\n </tr> \r\n </table>\r\n <!-- /End Main Template Table -->\r\n </td>\r\n </tr>\r\n </table>\r\n<!-- /End 100% Wrapping Table --> \r\n</body>\r\n</html>\r\n', ''),
+(3, NULL, 'auction-sale-buyer', 'Bid Successful.', 'firstName,familyName,vehicle,seller,price,seller_name,vehicle_address,seller_billing_address,seller_vat_number,seller_email', '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"\r\n "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">\r\n<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">\r\n<head>\r\n <meta http-equiv="Content-type" content="text/html; charset=utf-8" />\r\n <title></title>\r\n</head>\r\n<body style="padding:0;margin:0;">\r\n <!-- Begin 100% Wrapping Table -->\r\n <table border="0" cellspacing="0" cellpadding="0" width="100%" align="center" style="margin:0; padding:0;border-collapse:collapse; border-spacing:0;width:100%;">\r\n <tr>\r\n <td style="padding:20px 0;">\r\n <!-- Begin Main Template Table --> \r\n <table border="0" cellspacing="0" cellpadding="0" width="800" align="center" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px; margin:0 auto; line-height:1.33;">\r\n <tr>\r\n <td>\r\n <img src="http://{APP_HOST}/images/EmailHeader.png" width="800" height="100" alt="Please set images to always display for our emails" style="display:block;" />\r\n </td>\r\n </tr> \r\n <tr>\r\n <td style="background:#f6f6f6;padding:20px 0">\r\n <!-- Main Content table -->\r\n <table border="0" cellspacing="0" cellpadding="0" width="800" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <tr>\r\n <!-- Spacing Column -->\r\n <td width="20" valign="top" style="width:20px;"> </td>\r\n <!-- Main Column -->\r\n <td width="420" valign="top" style="width:420px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <h1 style="font-size:18px;margin:0 0 0.5em;padding:0;font-weight:400;">Bid Successful</h1>\r\n <p style="margin:0 0 1em;padding:0;">\r\n \r\n </p>\r\n <p style="margin:0 0 1em;padding:0;">\r\n Dear [first_name] [family_name],\r\n </p>\r\n <p style="margin:0 0 1em;padding:0;">\r\n Congratulations! You are the winning bidder of [vehicle] from [seller], at [price].\r\n </p>\r\n <p style="margin:0 0 1em;padding:0;">\r\n <b>Your responsibilities:</b>\r\n <ul>\r\n <li>Complete sale within two working days.</li>\r\n <li>Collect vehicle.</li>\r\n <li>Sign attachments when collecting vehicle.</li>\r\n </ul>\r\n </p>\r\n <p style="margin:0 0 1em;padding:0;">\r\n <b>Seller:</b>\r\n <table border="0" cellspacing="0" cellpadding="3px" width="420" style="border-collapse:collapse; border-spacing:0; margin:0; padding:3px; width:420px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <tr>\r\n <td width="80px"><b>Trading Name:</b></td>\r\n <td><b>[seller]</b></td>\r\n </tr>\r\n <tr>\r\n <td width="80px"><b>Full Name:</b></td>\r\n <td><b>[seller_name]</b></td>\r\n </tr>\r\n <tr>\r\n <td width="80px"><b>Auction Address:</b></td>\r\n <td><b>[vehicle_address]</b></td>\r\n </tr>\r\n <tr>\r\n <td width="80px"><b>Billing Address:</b></td>\r\n <td><b>[seller_billing_address]</b></td>\r\n </tr>\r\n <tr>\r\n <td width="80px"><b>VAT Number:</b></td>\r\n <td><b>[seller_vat_number]</b></td>\r\n </tr>\r\n <tr>\r\n <td width="80px"><b>E-mail:</b></td>\r\n <td><b>[seller_email]</b></td>\r\n </tr>\r\n </table>\r\n </p>\r\n <p style="margin:0 0 1em;padding:0;"><br/>\r\n Regards,<br/>\r\n The Bid4Cars Team\r\n </p>\r\n </td>\r\n <!-- Spacing Column -->\r\n <td width="40" valign="top" style="width:40px;"> </td>\r\n <!-- Side Column -->\r\n <td width="300" valign="top" style="width:300px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <img src="http://{APP_HOST}/images/hammer.gif" width="300px" alt="Content Image" align="left" style="padding:5px;" />\r\n <h2 style="font-size:18px;margin:20px 3px 0px;padding:0;font-weight:400;">Auctions</h2>\r\n <p style="margin:0 0 1em;padding:5px;">\r\n Online technology bringing buyers and sellers\r\n together through the Dealer Network.\r\n </p> \r\n </td>\r\n <!-- Spacing Column -->\r\n <td width="20" valign="top" style="width:20px;"> </td>\r\n </tr>\r\n </table>\r\n <!-- /Main Content Table --> \r\n </td> \r\n </tr>\r\n <tr>\r\n <td style="background:#ececec;padding:10px 0 0;">\r\n <!-- Begin Footer table -->\r\n <table border="0" cellspacing="0" cellpadding="0" width="600" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:600px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <tr>\r\n <!-- Spacing Column -->\r\n <td width="20" valign="top" style="width:20px;"> </td>\r\n <!-- Main Column -->\r\n <td width="560" valign="top" style="width:560px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <p style="margin:0 0 1em;padding:0;"><b>bid4cars.com.na</b></p>\r\n </td>\r\n <!-- Spacing Column --> \r\n <td width="20" valign="top" style="width:20px;"> </td>\r\n </tr>\r\n </table>\r\n <!-- /End Footer Table --> \r\n </td>\r\n </tr> \r\n </table>\r\n <!-- /End Main Template Table -->\r\n </td>\r\n </tr>\r\n </table>\r\n<!-- /End 100% Wrapping Table --> \r\n</body>\r\n</html>\r\n', 'Congratulations! You have won [vehicle] on Bid4Cars for [price]. Please check your e-mail for more info.'),
+(4, NULL, 'auction-sale-seller', 'Auction Successul.', 'firstName,familyName,vehicle,price,buyer,buyer_name,buyer_address,buyer_vat_number,buyer_mobile,buyer_email', '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"\r\n "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">\r\n<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">\r\n<head>\r\n <meta http-equiv="Content-type" content="text/html; charset=utf-8" />\r\n <title></title>\r\n</head>\r\n<body style="padding:0;margin:0;">\r\n <!-- Begin 100% Wrapping Table -->\r\n <table border="0" cellspacing="0" cellpadding="0" width="100%" align="center" style="margin:0; padding:0;border-collapse:collapse; border-spacing:0;width:100%;">\r\n <tr>\r\n <td style="padding:20px 0;">\r\n <!-- Begin Main Template Table --> \r\n <table border="0" cellspacing="0" cellpadding="0" width="800" align="center" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px; margin:0 auto; line-height:1.33;">\r\n <tr>\r\n <td>\r\n <img src="http://{APP_HOST}/images/EmailHeader.png" width="800" height="100" alt="Please set images to always display for our emails" style="display:block;" />\r\n </td>\r\n </tr> \r\n <tr>\r\n <td style="background:#f6f6f6;padding:20px 0">\r\n <!-- Main Content table -->\r\n <table border="0" cellspacing="0" cellpadding="0" width="800" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <tr>\r\n <!-- Spacing Column -->\r\n <td width="20" valign="top" style="width:20px;"> </td>\r\n <!-- Main Column -->\r\n <td width="420" valign="top" style="width:420px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <h1 style="font-size:18px;margin:0 0 0.5em;padding:0;font-weight:400;">Auction Successful</h1>\r\n <p style="margin:0 0 1em;padding:0;">\r\n \r\n </p>\r\n <p style="margin:0 0 1em;padding:0;">\r\n Hello [first_name] [family_name],\r\n </p>\r\n <p style="margin:0 0 1em;padding:0;">\r\n Congratulations! Your vehicle [vehicle] finished with a winning bid of [price] from [buyer].\r\n </p>\r\n <p style="margin:0 0 1em;padding:0;">\r\n <b>Your responsibilities:</b>\r\n <ul>\r\n <li>Invoice vehicle.</li>\r\n <li>Send Natis, invoice and bank details.</li>\r\n <li>Have vehicle ready for collection.</li>\r\n <li>Print attachments.</li>\r\n </ul>\r\n </p>\r\n <p style="margin:0 0 1em;padding:0;">\r\n <b>Buyer:</b>\r\n <table border="0" cellspacing="0" cellpadding="3px" width="420" style="border-collapse:collapse; border-spacing:0; margin:0; padding:3px; width:420px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <tr>\r\n <td width="80px"><b>Trading Name:</b></td>\r\n <td><b>[buyer]</b></td>\r\n </tr>\r\n <tr>\r\n <td width="80px"><b>Full Name:</b></td>\r\n <td><b>[buyer_name]</b></td>\r\n </tr>\r\n <tr>\r\n <td width="80px"><b>Physical Address:</b></td>\r\n <td><b>[buyer_address]</b></td>\r\n </tr>\r\n <tr>\r\n <td width="80px"><b>VAT Number:</b></td>\r\n <td><b>[buyer_vat_number]</b></td>\r\n </tr>\r\n <tr>\r\n <td width="80px"><b>Cellphone:</b></td>\r\n <td><b>[buyer_mobile]</b></td>\r\n </tr>\r\n <tr>\r\n <td width="80px"><b>E-mail:</b></td>\r\n <td><b>[buyer_email]</b></td>\r\n </tr>\r\n </table>\r\n </p>\r\n <p style="margin:0 0 1em;padding:0;"><br/>\r\n Regards,<br/>\r\n The Bid4Cars Team\r\n </p>\r\n </td>\r\n <!-- Spacing Column -->\r\n <td width="40" valign="top" style="width:40px;"> </td>\r\n <!-- Side Column -->\r\n <td width="300" valign="top" style="width:300px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <img src="http://{APP_HOST}/images/hammer.gif" width="300px" alt="Content Image" align="left" style="padding:5px;" />\r\n <h2 style="font-size:18px;margin:20px 3px 0px;padding:0;font-weight:400;">Auctions</h2>\r\n <p style="margin:0 0 1em;padding:5px;">\r\n Online technology bringing buyers and sellers\r\n together through the Dealer Network.\r\n </p> \r\n </td>\r\n <!-- Spacing Column -->\r\n <td width="20" valign="top" style="width:20px;"> </td>\r\n </tr>\r\n </table>\r\n <!-- /Main Content Table --> \r\n </td> \r\n </tr>\r\n <tr>\r\n <td style="background:#ececec;padding:10px 0 0;">\r\n <!-- Begin Footer table -->\r\n <table border="0" cellspacing="0" cellpadding="0" width="600" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:600px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <tr>\r\n <!-- Spacing Column -->\r\n <td width="20" valign="top" style="width:20px;"> </td>\r\n <!-- Main Column -->\r\n <td width="560" valign="top" style="width:560px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <p style="margin:0 0 1em;padding:0;"><b>bid4cars.com.na</b></p>\r\n </td>\r\n <!-- Spacing Column --> \r\n <td width="20" valign="top" style="width:20px;"> </td>\r\n </tr>\r\n </table>\r\n <!-- /End Footer Table --> \r\n </td>\r\n </tr> \r\n </table>\r\n <!-- /End Main Template Table -->\r\n </td>\r\n </tr>\r\n </table>\r\n<!-- /End 100% Wrapping Table --> \r\n</body>\r\n</html>\r\n', 'Congratulations! [vehicle] has been sold on Bid4Cars for [price]. Please check your e-mail and complete the necessary documentation.'),
+(5, NULL, 'auction-outbid', 'You have been outbid.', 'firstName,familyName,vehicle,seller,price,bid,auction_expiry_date', '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"\r\n "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">\r\n<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">\r\n<head>\r\n <meta http-equiv="Content-type" content="text/html; charset=utf-8" />\r\n <title></title>\r\n</head>\r\n<body style="padding:0;margin:0;">\r\n <!-- Begin 100% Wrapping Table -->\r\n <table border="0" cellspacing="0" cellpadding="0" width="100%" align="center" style="margin:0; padding:0;border-collapse:collapse; border-spacing:0;width:100%;">\r\n <tr>\r\n <td style="padding:20px 0;">\r\n <!-- Begin Main Template Table --> \r\n <table border="0" cellspacing="0" cellpadding="0" width="800" align="center" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px; margin:0 auto; line-height:1.33;">\r\n <tr>\r\n <td>\r\n <img src="http://{APP_HOST}/images/EmailHeader.png" width="800" height="100" alt="Please set images to always display for our emails" style="display:block;" />\r\n </td>\r\n </tr> \r\n <tr>\r\n <td style="background:#f6f6f6;padding:20px 0">\r\n <!-- Main Content table -->\r\n <table border="0" cellspacing="0" cellpadding="0" width="800" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <tr>\r\n <!-- Spacing Column -->\r\n <td width="20" valign="top" style="width:20px;"> </td>\r\n <!-- Main Column -->\r\n <td width="420" valign="top" style="width:420px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <h1 style="font-size:18px;margin:0 0 0.5em;padding:0;font-weight:400;">You have been outbid on [vehicle]</h1>\r\n <p style="margin:0 0 1em;padding:0;">\r\n \r\n </p>\r\n <p style="margin:0 0 1em;padding:0;">\r\n Dear [first_name] [family_name],\r\n </p>\r\n <p style="margin:0 0 1em;padding:0;">\r\n You have been outbid on the following vehicle: [vehicle] from [seller], next minimum bid is [price].\r\n Your bid of [bid] is no longer in the leading bid. The auction ends [auction_expiry_date].\r\n </p>\r\n <p style="margin:0 0 1em;padding:0;">\r\n Best of luck,<br/>\r\n The Bid4Cars Team\r\n </p>\r\n </td>\r\n <!-- Spacing Column -->\r\n <td width="40" valign="top" style="width:40px;"> </td>\r\n <!-- Side Column -->\r\n <td width="300" valign="top" style="width:300px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <img src="http://{APP_HOST}/images/hammer.gif" width="300px" alt="Content Image" align="left" style="padding:5px;" />\r\n <h2 style="font-size:18px;margin:20px 3px 0px;padding:0;font-weight:400;">Auctions</h2>\r\n <p style="margin:0 0 1em;padding:5px;">\r\n Online technology bringing buyers and sellers\r\n together through the Dealer Network.\r\n </p> \r\n </td>\r\n <!-- Spacing Column -->\r\n <td width="20" valign="top" style="width:20px;"> </td>\r\n </tr>\r\n </table>\r\n <!-- /Main Content Table --> \r\n </td> \r\n </tr>\r\n <tr>\r\n <td style="background:#ececec;padding:10px 0 0;">\r\n <!-- Begin Footer table -->\r\n <table border="0" cellspacing="0" cellpadding="0" width="800" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <tr>\r\n <!-- Spacing Column -->\r\n <td width="20" valign="top" style="width:20px;"> </td>\r\n <!-- Main Column -->\r\n <td width="380" valign="top" style="width:380px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <p style="margin:0 0 1em;padding:0;"><b>bid4cars.com.na</b></p>\r\n </td>\r\n <!-- Spacing Column --> \r\n <td width="380" valign="top" align="right" style="width:380px;">\r\n Click <a href="http://{APP_HOST}/unsubscribe/reminder">here</a> to unsubscribe from reminders.\r\n </td>\r\n <!-- Spacing Column -->\r\n <td width="20" valign="top" style="width:20px;"> </td>\r\n </tr>\r\n </table>\r\n <!-- /End Footer Table -->\r\n </td>\r\n </tr>\r\n </table>\r\n <!-- /End Main Template Table -->\r\n </td>\r\n </tr>\r\n </table>\r\n<!-- /End 100% Wrapping Table --> \r\n</body>\r\n</html>\r\n', 'You have been outbid on [vehicle], next minimum bid is [price]. Click here http://bid4cars.com.na/bid to continue bidding.'),
+(6, NULL, 'auction-question', 'Stock Question.', 'first_name,family_name,dealer,vehicle,question', '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"\r\n "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">\r\n<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">\r\n<head>\r\n <meta http-equiv="Content-type" content="text/html; charset=utf-8" />\r\n <title></title>\r\n</head>\r\n<body style="padding:0;margin:0;">\r\n <!-- Begin 100% Wrapping Table -->\r\n <table border="0" cellspacing="0" cellpadding="0" width="100%" align="center" style="margin:0; padding:0;border-collapse:collapse; border-spacing:0;width:100%;">\r\n <tr>\r\n <td style="padding:20px 0;">\r\n <!-- Begin Main Template Table -->\r\n <table border="0" cellspacing="0" cellpadding="0" width="800" align="center" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px; margin:0 auto; line-height:1.33;">\r\n <tr>\r\n <td>\r\n <img src="http://{APP_HOST}/images/EmailHeader.png" width="800" height="100" alt="Please set images to always display for our emails" style="display:block;" />\r\n </td>\r\n </tr>\r\n <tr>\r\n <td style="background:#f6f6f6;padding:20px 0">\r\n <!-- Main Content table -->\r\n <table border="0" cellspacing="0" cellpadding="0" width="800" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <tr>\r\n <!-- Spacing Column -->\r\n <td width="20" valign="top" style="width:20px;"> </td>\r\n <!-- Main Column -->\r\n <td width="420" valign="top" style="width:420px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <h1 style="font-size:18px;margin:0 0 0.5em;padding:0;font-weight:400;">Stock Question</h1>\r\n <p style="margin:0 0 1em;padding:0;">\r\n \r\n </p>\r\n <p style="margin:0 0 1em;padding:0;">\r\n Dear [first_name] [family_name],\r\n </p>\r\n <p style="margin:0 0 1em;padding:0;">\r\n You have a question from [dealer] concerning vehicle [vehicle].\r\n </p>\r\n <p style="margin:0 0 1em;padding:0;">\r\n <b>Question:</b> [question]\r\n </p>\r\n <p style="margin:0 0 1em;padding:0;">\r\n \r\n </p>\r\n <p style="margin:0 0 1em;padding:0;">\r\n You can reply to the question in <i>My settings</i> page.\r\n </p>\r\n <p style="margin:0 0 1em;padding:0;">\r\n Regards,<br/>\r\n The Bid4Cars Team\r\n </p>\r\n </td>\r\n <!-- Spacing Column -->\r\n <td width="40" valign="top" style="width:40px;"> </td>\r\n <!-- Side Column -->\r\n <td width="300" valign="top" style="width:300px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <img src="http://{APP_HOST}/images/waiting.gif" width="300px" alt="Content Image" align="left" style="padding:5px;" />\r\n <h2 style="font-size:18px;margin:20px 3px 0px;padding:0;font-weight:400;">Need help?</h2>\r\n <p style="margin:0 0 1em;padding:5px;">\r\n If you have any questions please feel free to contact us for assistance.\r\n </p>\r\n </td>\r\n <!-- Spacing Column -->\r\n <td width="20" valign="top" style="width:20px;"> </td>\r\n </tr>\r\n </table>\r\n <!-- /Main Content Table -->\r\n </td>\r\n </tr>\r\n <tr>\r\n <td style="background:#ececec;padding:10px 0 0;">\r\n <!-- Begin Footer table -->\r\n <table border="0" cellspacing="0" cellpadding="0" width="800" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <tr>\r\n <!-- Spacing Column -->\r\n <td width="20" valign="top" style="width:20px;"> </td>\r\n <!-- Main Column -->\r\n <td width="380" valign="top" style="width:380px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <p style="margin:0 0 1em;padding:0;"><b>bid4cars.com.na</b></p>\r\n </td>\r\n <!-- Spacing Column -->\r\n <td width="380" valign="top" align="right" style="width:380px;">\r\n \r\n </td>\r\n <!-- Spacing Column -->\r\n <td width="20" valign="top" style="width:20px;"> </td>\r\n </tr>\r\n </table>\r\n <!-- /End Footer Table -->\r\n </td>\r\n </tr>\r\n </table>\r\n <!-- /End Main Template Table -->\r\n </td>\r\n </tr>\r\n </table>\r\n<!-- /End 100% Wrapping Table -->\r\n</body>\r\n</html>\r\n', ''),
+(7, NULL, 'auction-reply', 'Stock Reply.', 'first_name,family_name,dealer,vehicle,question,reply', '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"\r\n "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">\r\n<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">\r\n<head>\r\n <meta http-equiv="Content-type" content="text/html; charset=utf-8" />\r\n <title></title>\r\n</head>\r\n<body style="padding:0;margin:0;">\r\n <!-- Begin 100% Wrapping Table -->\r\n <table border="0" cellspacing="0" cellpadding="0" width="100%" align="center" style="margin:0; padding:0;border-collapse:collapse; border-spacing:0;width:100%;">\r\n <tr>\r\n <td style="padding:20px 0;">\r\n <!-- Begin Main Template Table -->\r\n <table border="0" cellspacing="0" cellpadding="0" width="800" align="center" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px; margin:0 auto; line-height:1.33;">\r\n <tr>\r\n <td>\r\n <img src="http://{APP_HOST}/images/EmailHeader.png" width="800" height="100" alt="Please set images to always display for our emails" style="display:block;" />\r\n </td>\r\n </tr>\r\n <tr>\r\n <td style="background:#f6f6f6;padding:20px 0">\r\n <!-- Main Content table -->\r\n <table border="0" cellspacing="0" cellpadding="0" width="800" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <tr>\r\n <!-- Spacing Column -->\r\n <td width="20" valign="top" style="width:20px;"> </td>\r\n <!-- Main Column -->\r\n <td width="420" valign="top" style="width:420px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <h1 style="font-size:18px;margin:0 0 0.5em;padding:0;font-weight:400;">Stock Reply</h1>\r\n <p style="margin:0 0 1em;padding:0;">\r\n \r\n </p>\r\n <p style="margin:0 0 1em;padding:0;">\r\n Dear [first_name] [family_name],\r\n </p>\r\n <p style="margin:0 0 1em;padding:0;">\r\n Your question to [dealer] concerning vehicle [vehicle] have received a reply.\r\n </p>\r\n <p style="margin:0 0 1em;padding:0;">\r\n <b>Question:</b> [question]\r\n </p>\r\n <p style="margin:0 0 1em;padding:0;">\r\n <b>Reply:</b> [reply]\r\n </p>\r\n <p style="margin:0 0 1em;padding:0;">\r\n \r\n </p>\r\n <p style="margin:0 0 1em;padding:0;">\r\n Regards,<br/>\r\n The Bid4Cars Team\r\n </p>\r\n </td>\r\n <!-- Spacing Column -->\r\n <td width="40" valign="top" style="width:40px;"> </td>\r\n <!-- Side Column -->\r\n <td width="300" valign="top" style="width:300px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <img src="http://{APP_HOST}/images/waiting.gif" width="300px" alt="Content Image" align="left" style="padding:5px;" />\r\n <h2 style="font-size:18px;margin:20px 3px 0px;padding:0;font-weight:400;">Need help?</h2>\r\n <p style="margin:0 0 1em;padding:5px;">\r\n If you have any questions please feel free to contact us for assistance.\r\n </p>\r\n </td>\r\n <!-- Spacing Column -->\r\n <td width="20" valign="top" style="width:20px;"> </td>\r\n </tr>\r\n </table>\r\n <!-- /Main Content Table -->\r\n </td>\r\n </tr>\r\n <tr>\r\n <td style="background:#ececec;padding:10px 0 0;">\r\n <!-- Begin Footer table -->\r\n <table border="0" cellspacing="0" cellpadding="0" width="800" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <tr>\r\n <!-- Spacing Column -->\r\n <td width="20" valign="top" style="width:20px;"> </td>\r\n <!-- Main Column -->\r\n <td width="380" valign="top" style="width:380px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <p style="margin:0 0 1em;padding:0;"><b>bid4cars.com.na</b></p>\r\n </td>\r\n <!-- Spacing Column -->\r\n <td width="380" valign="top" align="right" style="width:380px;">\r\n \r\n </td>\r\n <!-- Spacing Column -->\r\n <td width="20" valign="top" style="width:20px;"> </td>\r\n </tr>\r\n </table>\r\n <!-- /End Footer Table -->\r\n </td>\r\n </tr>\r\n </table>\r\n <!-- /End Main Template Table -->\r\n </td>\r\n </tr>\r\n </table>\r\n<!-- /End 100% Wrapping Table -->\r\n</body>\r\n</html>\r\n', ''),
(8, NULL, 'forgot-pin', 'Your pin was reset on the Bid 4 Cars website.', 'firstName,familyName,email,pin', '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"\r\n "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">\r\n<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">\r\n<head>\r\n <meta http-equiv="Content-type" content="text/html; charset=utf-8" />\r\n <title></title>\r\n</head>\r\n<body style="padding:0;margin:0;">\r\n <!-- Begin 100% Wrapping Table -->\r\n <table border="0" cellspacing="0" cellpadding="0" width="100%" align="center" style="margin:0; padding:0;border-collapse:collapse; border-spacing:0;width:100%;">\r\n <tr>\r\n <td style="padding:20px 0;">\r\n <!-- Begin Main Template Table -->\r\n <table border="0" cellspacing="0" cellpadding="0" width="800" align="center" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px; margin:0 auto; line-height:1.33;">\r\n <tr>\r\n <td>\r\n <img src="{APP_HOST}/images/EmailHeader.png" width="800" height="100" alt="Please set images to always display for our emails" style="display:block;" />\r\n </td>\r\n </tr>\r\n <tr>\r\n <td style="background:#f6f6f6;padding:20px 0">\r\n <!-- Main Content table -->\r\n <table border="0" cellspacing="0" cellpadding="0" width="800" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <tr>\r\n <!-- Spacing Column -->\r\n <td width="20" valign="top" style="width:20px;"> </td>\r\n <!-- Main Column -->\r\n <td width="420" valign="top" style="width:420px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <h1 style="font-size:18px;margin:0 0 0.5em;padding:0;font-weight:400;">Pin Reset</h1>\r\n <p style="margin:0 0 1em;padding:0;">\r\n \r\n </p>\r\n <p style="margin:0 0 1em;padding:0;">\r\n Dear [firstName] [familyName],\r\n </p>\r\n <p style="margin:0 0 1em;padding:0;">\r\n Your pin was reset on the Bid 4 Cars website.\r\n Here is your new login details:\r\n <table border="0" cellspacing="0" cellpadding="3px" width="420" style="border-collapse:collapse; border-spacing:0; margin:0; padding:3px; width:420px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <tr>\r\n <td width="80px"><b>Username:</b></td>\r\n <td><b>[email]</b></td>\r\n </tr>\r\n <tr>\r\n <td><b>Pin:</b></td>\r\n <td><b>[pin]</b></td>\r\n </tr>\r\n </table>\r\n </p>\r\n <p style="margin:0 0 1em;padding:0;">\r\n \r\n </p>\r\n <p style="margin:0 0 1em;padding:0;">\r\n To login please go to <i><a href="{APP_HOST}/#/login">{APP_HOST}/#/login</a></i>\r\n </p>\r\n <p style="margin:0 0 1em;padding:0;">\r\n Regards,<br/>\r\n The Bid4Cars Team\r\n </p>\r\n </td>\r\n <!-- Spacing Column -->\r\n <td width="40" valign="top" style="width:40px;"> </td>\r\n <!-- Side Column -->\r\n <td width="300" valign="top" style="width:300px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <img src="http://{APP_HOST}/images/reset-button.jpg" width="300px" alt="Content Image" align="left" style="padding:5px;" />\r\n <h2 style="font-size:18px;margin:20px 3px 0px;padding:0;font-weight:400;">Reset</h2>\r\n <p style="margin:0 0 1em;padding:5px;">\r\n Please remember to change your pin once logged in.\r\n </p>\r\n </td>\r\n <!-- Spacing Column -->\r\n <td width="20" valign="top" style="width:20px;"> </td>\r\n </tr>\r\n </table>\r\n <!-- /Main Content Table -->\r\n </td>\r\n </tr>\r\n <tr>\r\n <td style="background:#ececec;padding:10px 0 0;">\r\n <!-- Begin Footer table -->\r\n <table border="0" cellspacing="0" cellpadding="0" width="600" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:600px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <tr>\r\n <!-- Spacing Column -->\r\n <td width="20" valign="top" style="width:20px;"> </td>\r\n <!-- Main Column -->\r\n <td width="560" valign="top" style="width:560px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <p style="margin:0 0 1em;padding:0;"><b>{APP_HOST}</b></p>\r\n </td>\r\n <!-- Spacing Column -->\r\n <td width="20" valign="top" style="width:20px;"> </td>\r\n </tr>\r\n </table>\r\n <!-- /End Footer Table -->\r\n </td>\r\n </tr>\r\n </table>\r\n <!-- /End Main Template Table -->\r\n </td>\r\n </tr>\r\n </table>\r\n<!-- /End 100% Wrapping Table -->\r\n</body>\r\n</html>\r\n', 'Your new pin is [pin]. Details also sent via email.'),
(9, NULL, 'valuation-mobile-new', 'New mobile valuation.', 'firstName,familyName,vehicle_reg,customer_name, customer_family_name', '', '[firstName] [familyName] requested a valuation on [vehicle_reg], for [customer_name] [customer_family_name].'),
(10, NULL, 'valuation-completed', 'Valuation Completed.', 'firstName,familyName,customer.name,customer.familyName,dateCreated,refNo,valNo,year,make,model,type,regNo,salesComments', '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"\r\n "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">\r\n<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">\r\n<head>\r\n <meta http-equiv="Content-type" content="text/html; charset=utf-8" />\r\n <title></title>\r\n</head>\r\n<body style="padding:0;margin:0;">\r\n <!-- Begin 100% Wrapping Table -->\r\n <table border="0" cellspacing="0" cellpadding="0" width="100%" align="center" style="margin:0; padding:0;border-collapse:collapse; border-spacing:0;width:100%;">\r\n <tr>\r\n <td style="padding:20px 0;">\r\n <!-- Begin Main Template Table -->\r\n <table border="0" cellspacing="0" cellpadding="0" width="800" align="center" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px; margin:0 auto; line-height:1.33;">\r\n <tr>\r\n <td>\r\n <img src="{APP_HOST}/images/EmailHeader.png" width="800" height="100" alt="Please set images to always display for our emails" style="display:block;" />\r\n </td>\r\n </tr>\r\n <tr>\r\n <td style="background:#f6f6f6;padding:20px 0">\r\n <!-- Main Content table -->\r\n <table border="0" cellspacing="0" cellpadding="0" width="800" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <tr>\r\n <!-- Spacing Column -->\r\n <td width="20" valign="top" style="width:20px;"> </td>\r\n <!-- Main Column -->\r\n <td width="420" valign="top" style="width:420px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <h1 style="font-size:18px;margin:0 0 0.5em;padding:0;font-weight:400;">Valuation Completed</h1>\r\n <p style="margin:0 0 1em;padding:0;">\r\n \r\n </p>\r\n <p style="margin:0 0 1em;padding:0;">\r\n Dear [firstName] [familyName],\r\n </p>\r\n <p style="margin:0 0 1em;padding:0;">\r\n your valuation for [customer.name] [customer.familyName] has been completed.\r\n </p>\r\n <p style="margin:0 0 1em;padding:0;">\r\n [dateCreated], [refNo], [valNo].\r\n </p>\r\n <p style="margin:0 0 1em;padding:0;">\r\n Vehicle: [year], [make], [model], [type], [regNo]\r\n </p>\r\n <p style="margin:0 0 1em;padding:0;">[salesComments]</p>\r\n </td>\r\n <!-- Spacing Column -->\r\n <td width="40" valign="top" style="width:40px;"> </td>\r\n <!-- Side Column -->\r\n <td width="300" valign="top" style="width:300px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <img src="http://{APP_HOST}/images/handshake.png" width="300px" alt="Content Image" align="left" style="padding:5px;" />\r\n <h2 style="font-size:18px;margin:20px 3px 0px;padding:0;font-weight:400;">Bid4Cars</h2>\r\n <p style="margin:0 0 1em;padding:5px;">\r\n Online technology bringing buyers and sellers\r\n together through the Dealer Network.\r\n </p>\r\n </td>\r\n <!-- Spacing Column -->\r\n <td width="20" valign="top" style="width:20px;"> </td>\r\n </tr>\r\n </table>\r\n <!-- /Main Content Table -->\r\n </td>\r\n </tr>\r\n <tr>\r\n <td style="background:#ececec;padding:10px 0 0;">\r\n <!-- Begin Footer table -->\r\n <table border="0" cellspacing="0" cellpadding="0" width="800" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <tr>\r\n <!-- Spacing Column -->\r\n <td width="20" valign="top" style="width:20px;"> </td>\r\n <!-- Main Column -->\r\n <td width="380" valign="top" style="width:380px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <p style="margin:0 0 1em;padding:0;"><b>{APP_HOST}</b></p>\r\n </td>\r\n <!-- Spacing Column -->\r\n <td width="380" valign="top" align="right" style="width:380px;">\r\n Click <a href="http://{APP_HOST}/unsubscribe/reminder">here</a> to unsubscribe from reminders.\r\n </td>\r\n <!-- Spacing Column -->\r\n <td width="20" valign="top" style="width:20px;"> </td>\r\n </tr>\r\n </table>\r\n <!-- /End Footer Table -->\r\n </td>\r\n </tr>\r\n </table>\r\n <!-- /End Main Template Table -->\r\n </td>\r\n </tr>\r\n </table>\r\n<!-- /End 100% Wrapping Table -->\r\n</body>\r\n</html>\r\n', 'Your valuation for [customer.name] [customer.familyName], [regNo] was completed, please check your mail.');
(19, NULL, 'activation-pending', 'Activation of your registration on Bid4Cars is still pending.', 'firstName,familyName,message', '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"\r\n "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">\r\n<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">\r\n<head>\r\n <meta http-equiv="Content-type" content="text/html; charset=utf-8" />\r\n <title></title>\r\n</head>\r\n<body style="padding:0;margin:0;">\r\n <!-- Begin 100% Wrapping Table -->\r\n <table border="0" cellspacing="0" cellpadding="0" width="100%" align="center" style="margin:0; padding:0;border-collapse:collapse; border-spacing:0;width:100%;">\r\n <tr>\r\n <td style="padding:20px 0;">\r\n <!-- Begin Main Template Table -->\r\n <table border="0" cellspacing="0" cellpadding="0" width="800" align="center" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px; margin:0 auto; line-height:1.33;">\r\n <tr>\r\n <td>\r\n <img src="{APP_HOST}/images/EmailHeader.png" width="800" height="100" alt="Please set images to always display for our emails" style="display:block;" />\r\n </td>\r\n </tr>\r\n <tr>\r\n <td style="background:#f6f6f6;padding:20px 0">\r\n <!-- Main Content table -->\r\n <table border="0" cellspacing="0" cellpadding="0" width="800" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <tr>\r\n <!-- Spacing Column -->\r\n <td width="20" valign="top" style="width:20px;"> </td>\r\n <!-- Main Column -->\r\n <td width="420" valign="top" style="width:420px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <h1 style="font-size:18px;margin:0 0 0.5em;padding:0;font-weight:400;">Activation Pending</h1>\r\n <p style="margin:0 0 1em;padding:0;">\r\n \r\n </p>\r\n <p style="margin:0 0 1em;padding:0;">\r\n Dear [firstName] [familyName],\r\n </p>\r\n <p style="margin:0 0 1em;padding:0;">\r\n Activation of your registration on Bid4Cars is still pending.\r\n </p>\r\n <p style="margin:0 0 1em;padding:0;">\r\n <b>Message:</b> [message]\r\n </p>\r\n <p style="margin:0 0 1em;padding:0;">\r\n Regards,<br/>\r\n The Bid4Cars Team\r\n </p>\r\n </td>\r\n <!-- Spacing Column -->\r\n <td width="40" valign="top" style="width:40px;"> </td>\r\n <!-- Side Column -->\r\n <td width="300" valign="top" style="width:300px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <img src="http://{APP_HOST}/images/handshake.png" width="300px" alt="Content Image" align="left" style="padding:5px;" />\r\n <h2 style="font-size:18px;margin:20px 3px 0px;padding:0;font-weight:400;">Bid4Cars</h2>\r\n <p style="margin:0 0 1em;padding:5px;">\r\n Online technology bringing buyers and sellers\r\n together through the Dealer Network.\r\n </p>\r\n </td>\r\n <!-- Spacing Column -->\r\n <td width="20" valign="top" style="width:20px;"> </td>\r\n </tr>\r\n </table>\r\n <!-- /Main Content Table -->\r\n </td>\r\n </tr>\r\n <tr>\r\n <td style="background:#ececec;padding:10px 0 0;">\r\n <!-- Begin Footer table -->\r\n <table border="0" cellspacing="0" cellpadding="0" width="800" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <tr>\r\n <!-- Spacing Column -->\r\n <td width="20" valign="top" style="width:20px;"> </td>\r\n <!-- Main Column -->\r\n <td width="380" valign="top" style="width:380px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <p style="margin:0 0 1em;padding:0;"><b>{APP_HOST}</b></p>\r\n </td>\r\n <!-- Spacing Column -->\r\n <td width="380" valign="top" align="right" style="width:380px;">\r\n \r\n </td>\r\n <!-- Spacing Column -->\r\n <td width="20" valign="top" style="width:20px;"> </td>\r\n </tr>\r\n </table>\r\n <!-- /End Footer Table -->\r\n </td>\r\n </tr>\r\n </table>\r\n <!-- /End Main Template Table -->\r\n </td>\r\n </tr>\r\n </table>\r\n<!-- /End 100% Wrapping Table -->\r\n</body>\r\n</html>\r\n', ''),
(20, NULL, 'registration-pending', 'Your application was flagged as pending.', 'firstName,familyName,status_reason', '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"\r\n "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">\r\n<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">\r\n<head>\r\n <meta http-equiv="Content-type" content="text/html; charset=utf-8" />\r\n <title></title>\r\n</head>\r\n<body style="padding:0;margin:0;">\r\n <!-- Begin 100% Wrapping Table -->\r\n <table border="0" cellspacing="0" cellpadding="0" width="100%" align="center" style="margin:0; padding:0;border-collapse:collapse; border-spacing:0;width:100%;">\r\n <tr>\r\n <td style="padding:20px 0;">\r\n <!-- Begin Main Template Table --> \r\n <table border="0" cellspacing="0" cellpadding="0" width="800" align="center" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px; margin:0 auto; line-height:1.33;">\r\n <tr>\r\n <td>\r\n <img src="{APP_HOST}/images/EmailHeader.png" width="800" height="100" alt="Please set images to always display for our emails" style="display:block;" />\r\n </td>\r\n </tr> \r\n <tr>\r\n <td style="background:#f6f6f6;padding:20px 0">\r\n <!-- Main Content table -->\r\n <table border="0" cellspacing="0" cellpadding="0" width="800" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <tr>\r\n <!-- Spacing Column -->\r\n <td width="20" valign="top" style="width:20px;"> </td>\r\n <!-- Main Column -->\r\n <td width="420" valign="top" style="width:420px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <h1 style="font-size:18px;margin:0 0 0.5em;padding:0;font-weight:400;">Registration Pending</h1>\r\n <p style="margin:0 0 1em;padding:0;">\r\n \r\n </p>\r\n <p style="margin:0 0 1em;padding:0;">\r\n Dear [firstName] [familyName],\r\n </p>\r\n <p style="margin:0 0 1em;padding:0;">\r\n Your application was flagged as pending for the following reason:\r\n </p>\r\n <p style="margin:0 0 1em;padding:0;">\r\n [status_reason]\r\n </p>\r\n <p style="margin:0 0 1em;padding:0;">\r\n \r\n </p>\r\n <p style="margin:0 0 1em;padding:0;">\r\n You will be notified via email if your application is either approved or declined.\r\n </p>\r\n <p style="margin:0 0 1em;padding:0;">\r\n Regards,<br/>\r\n The Bid4Cars Team\r\n </p>\r\n </td>\r\n <!-- Spacing Column -->\r\n <td width="40" valign="top" style="width:40px;"> </td>\r\n <!-- Side Column -->\r\n <td width="300" valign="top" style="width:300px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <img src="http://{APP_HOST}/images/waiting.gif" width="300px" alt="Content Image" align="left" style="padding:5px;" />\r\n <h2 style="font-size:18px;margin:20px 3px 0px;padding:0;font-weight:400;">Need help?</h2>\r\n <p style="margin:0 0 1em;padding:5px;">\r\n If you have any questions please feel free to contact us for assistance.\r\n </p> \r\n </td>\r\n <!-- Spacing Column -->\r\n <td width="20" valign="top" style="width:20px;"> </td>\r\n </tr>\r\n </table>\r\n <!-- /Main Content Table --> \r\n </td> \r\n </tr>\r\n <tr>\r\n <td style="background:#ececec;padding:10px 0 0;">\r\n <!-- Begin Footer table -->\r\n <table border="0" cellspacing="0" cellpadding="0" width="800" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <tr>\r\n <!-- Spacing Column -->\r\n <td width="20" valign="top" style="width:20px;"> </td>\r\n <!-- Main Column -->\r\n <td width="380" valign="top" style="width:380px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <p style="margin:0 0 1em;padding:0;"><b>{APP_HOST}</b></p>\r\n </td>\r\n <!-- Spacing Column --> \r\n <td width="380" valign="top" align="right" style="width:380px;">\r\n Click <a href="http://{APP_HOST}/unsubscribe/reminder">here</a> to unsubscribe from reminders.\r\n </td>\r\n <!-- Spacing Column -->\r\n <td width="20" valign="top" style="width:20px;"> </td>\r\n </tr>\r\n </table>\r\n <!-- /End Footer Table -->\r\n </td>\r\n </tr>\r\n </table>\r\n <!-- /End Main Template Table -->\r\n </td>\r\n </tr>\r\n </table>\r\n<!-- /End 100% Wrapping Table --> \r\n</body>\r\n</html>\r\n', '');
INSERT INTO `lib_template` (`id`, `lib_repeater_template_id`, `name`, `subject`, `tags`, `email_template`, `sms_template`) VALUES
-(21, NULL, 'registration-declined', 'Your application was declined.', 'firstName,familyName,status_reason', '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"\r\n "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">\r\n<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">\r\n<head>\r\n <meta http-equiv="Content-type" content="text/html; charset=utf-8" />\r\n <title></title>\r\n</head>\r\n<body style="padding:0;margin:0;">\r\n <!-- Begin 100% Wrapping Table -->\r\n <table border="0" cellspacing="0" cellpadding="0" width="100%" align="center" style="margin:0; padding:0;border-collapse:collapse; border-spacing:0;width:100%;">\r\n <tr>\r\n <td style="padding:20px 0;">\r\n <!-- Begin Main Template Table --> \r\n <table border="0" cellspacing="0" cellpadding="0" width="800" align="center" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px; margin:0 auto; line-height:1.33;">\r\n <tr>\r\n <td>\r\n <img src="{APP_HOST}/images/EmailHeader.png" width="800" height="100" alt="Please set images to always display for our emails" style="display:block;" />\r\n </td>\r\n </tr> \r\n <tr>\r\n <td style="background:#f6f6f6;padding:20px 0">\r\n <!-- Main Content table -->\r\n <table border="0" cellspacing="0" cellpadding="0" width="800" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <tr>\r\n <!-- Spacing Column -->\r\n <td width="20" valign="top" style="width:20px;"> </td>\r\n <!-- Main Column -->\r\n <td width="420" valign="top" style="width:420px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <h1 style="font-size:18px;margin:0 0 0.5em;padding:0;font-weight:400;">Registration Declined</h1>\r\n <p style="margin:0 0 1em;padding:0;">\r\n \r\n </p>\r\n <p style="margin:0 0 1em;padding:0;">\r\n Dear [firstName] [familyName],\r\n </p>\r\n <p style="margin:0 0 1em;padding:0;">\r\n Your application was declined for the following reason:\r\n </p>\r\n <p style="margin:0 0 1em;padding:0;">\r\n [status_reason]\r\n </p>\r\n <p style="margin:0 0 1em;padding:0;">\r\n Regards,<br/>\r\n The Bid4Cars Team\r\n </p>\r\n </td>\r\n <!-- Spacing Column -->\r\n <td width="40" valign="top" style="width:40px;"> </td>\r\n <!-- Side Column -->\r\n <td width="300" valign="top" style="width:300px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <img src="http://{APP_HOST}/images/noaccess.png" width="300px" alt="Content Image" align="left" style="padding:5px;" />\r\n <h2 style="font-size:18px;margin:20px 3px 0px;padding:0;font-weight:400;">Have we made an error?</h2>\r\n <p style="margin:0 0 1em;padding:5px;">\r\n If you feel that we have made a mistake please contact us with the\r\n relevant details so that we can have another look.\r\n </p> \r\n </td>\r\n <!-- Spacing Column -->\r\n <td width="20" valign="top" style="width:20px;"> </td>\r\n </tr>\r\n </table>\r\n <!-- /Main Content Table --> \r\n </td> \r\n </tr>\r\n <tr>\r\n <td style="background:#ececec;padding:10px 0 0;">\r\n <!-- Begin Footer table -->\r\n <table border="0" cellspacing="0" cellpadding="0" width="600" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:600px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <tr>\r\n <!-- Spacing Column -->\r\n <td width="20" valign="top" style="width:20px;"> </td>\r\n <!-- Main Column -->\r\n <td width="560" valign="top" style="width:560px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <p style="margin:0 0 1em;padding:0;"><b>bid4cars.co.za</b></p>\r\n </td>\r\n <!-- Spacing Column --> \r\n <td width="20" valign="top" style="width:20px;"> </td>\r\n </tr>\r\n </table>\r\n <!-- /End Footer Table --> \r\n </td>\r\n </tr> \r\n </table>\r\n <!-- /End Main Template Table -->\r\n </td>\r\n </tr>\r\n </table>\r\n<!-- /End 100% Wrapping Table --> \r\n</body>\r\n</html>\r\n', ''),
+(21, NULL, 'registration-declined', 'Your application was declined.', 'firstName,familyName,status_reason', '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"\r\n "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">\r\n<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">\r\n<head>\r\n <meta http-equiv="Content-type" content="text/html; charset=utf-8" />\r\n <title></title>\r\n</head>\r\n<body style="padding:0;margin:0;">\r\n <!-- Begin 100% Wrapping Table -->\r\n <table border="0" cellspacing="0" cellpadding="0" width="100%" align="center" style="margin:0; padding:0;border-collapse:collapse; border-spacing:0;width:100%;">\r\n <tr>\r\n <td style="padding:20px 0;">\r\n <!-- Begin Main Template Table --> \r\n <table border="0" cellspacing="0" cellpadding="0" width="800" align="center" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px; margin:0 auto; line-height:1.33;">\r\n <tr>\r\n <td>\r\n <img src="{APP_HOST}/images/EmailHeader.png" width="800" height="100" alt="Please set images to always display for our emails" style="display:block;" />\r\n </td>\r\n </tr> \r\n <tr>\r\n <td style="background:#f6f6f6;padding:20px 0">\r\n <!-- Main Content table -->\r\n <table border="0" cellspacing="0" cellpadding="0" width="800" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <tr>\r\n <!-- Spacing Column -->\r\n <td width="20" valign="top" style="width:20px;"> </td>\r\n <!-- Main Column -->\r\n <td width="420" valign="top" style="width:420px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <h1 style="font-size:18px;margin:0 0 0.5em;padding:0;font-weight:400;">Registration Declined</h1>\r\n <p style="margin:0 0 1em;padding:0;">\r\n \r\n </p>\r\n <p style="margin:0 0 1em;padding:0;">\r\n Dear [firstName] [familyName],\r\n </p>\r\n <p style="margin:0 0 1em;padding:0;">\r\n Your application was declined for the following reason:\r\n </p>\r\n <p style="margin:0 0 1em;padding:0;">\r\n [status_reason]\r\n </p>\r\n <p style="margin:0 0 1em;padding:0;">\r\n Regards,<br/>\r\n The Bid4Cars Team\r\n </p>\r\n </td>\r\n <!-- Spacing Column -->\r\n <td width="40" valign="top" style="width:40px;"> </td>\r\n <!-- Side Column -->\r\n <td width="300" valign="top" style="width:300px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <img src="http://{APP_HOST}/images/noaccess.png" width="300px" alt="Content Image" align="left" style="padding:5px;" />\r\n <h2 style="font-size:18px;margin:20px 3px 0px;padding:0;font-weight:400;">Have we made an error?</h2>\r\n <p style="margin:0 0 1em;padding:5px;">\r\n If you feel that we have made a mistake please contact us with the\r\n relevant details so that we can have another look.\r\n </p> \r\n </td>\r\n <!-- Spacing Column -->\r\n <td width="20" valign="top" style="width:20px;"> </td>\r\n </tr>\r\n </table>\r\n <!-- /Main Content Table --> \r\n </td> \r\n </tr>\r\n <tr>\r\n <td style="background:#ececec;padding:10px 0 0;">\r\n <!-- Begin Footer table -->\r\n <table border="0" cellspacing="0" cellpadding="0" width="600" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:600px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <tr>\r\n <!-- Spacing Column -->\r\n <td width="20" valign="top" style="width:20px;"> </td>\r\n <!-- Main Column -->\r\n <td width="560" valign="top" style="width:560px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <p style="margin:0 0 1em;padding:0;"><b>bid4cars.com.na</b></p>\r\n </td>\r\n <!-- Spacing Column --> \r\n <td width="20" valign="top" style="width:20px;"> </td>\r\n </tr>\r\n </table>\r\n <!-- /End Footer Table --> \r\n </td>\r\n </tr> \r\n </table>\r\n <!-- /End Main Template Table -->\r\n </td>\r\n </tr>\r\n </table>\r\n<!-- /End 100% Wrapping Table --> \r\n</body>\r\n</html>\r\n', ''),
(22, NULL, 'registration-success', 'Congratulations, your registration has been approved!', 'firstName,familyName,email', '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"\r\n "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">\r\n<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">\r\n<head>\r\n <meta http-equiv="Content-type" content="text/html; charset=utf-8" />\r\n <title></title>\r\n</head>\r\n<body style="padding:0;margin:0;">\r\n <!-- Begin 100% Wrapping Table -->\r\n <table border="0" cellspacing="0" cellpadding="0" width="100%" align="center" style="margin:0; padding:0;border-collapse:collapse; border-spacing:0;width:100%;">\r\n <tr>\r\n <td style="padding:20px 0;">\r\n <!-- Begin Main Template Table -->\r\n <table border="0" cellspacing="0" cellpadding="0" width="800" align="center" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px; margin:0 auto; line-height:1.33;">\r\n <tr>\r\n <td>\r\n <img src="{APP_HOST}/images/EmailHeader.png" width="800" height="100" alt="Please set images to always display for our emails" style="display:block;" />\r\n </td>\r\n </tr>\r\n <tr>\r\n <td style="background:#f6f6f6;padding:20px 0">\r\n <!-- Main Content table -->\r\n <table border="0" cellspacing="0" cellpadding="0" width="800" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <tr>\r\n <!-- Spacing Column -->\r\n <td width="20" valign="top" style="width:20px;"> </td>\r\n <!-- Main Column -->\r\n <td width="420" valign="top" style="width:420px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <h1 style="font-size:18px;margin:0 0 0.5em;padding:0;font-weight:400;">Congratulations, your registration has been approved!</h1>\r\n <p style="margin:0 0 1em;padding:0;">\r\n \r\n </p>\r\n <p style="margin:0 0 1em;padding:0;">\r\n Hello again [firstName] [familyName], and a very warm welcome!\r\n </p>\r\n <p style="margin:0 0 1em;padding:0;">\r\n Congratulations! We are delighted to advise you that your application as an official user of the Bid4Cars online vehicle management system has been approved.\r\n </p>\r\n <p style="margin:0 0 1em;padding:0;">\r\n To log in to your account, please click on the link below and enter the username and PIN provided.\r\n </p>\r\n <p style="margin:0 0 1em;padding:0;">\r\n Here are your login details:\r\n <table border="0" cellspacing="0" cellpadding="3px" width="420" style="border-collapse:collapse; border-spacing:0; margin:0; padding:3px; width:420px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <tr>\r\n <td width="80px"><b>Username:</b></td>\r\n <td><b>[email]</b></td>\r\n </tr>\r\n <tr>\r\n <td><b>Pin:</b></td>\r\n <td><b><i>* As entered on registration</i></b></td>\r\n </tr>\r\n </table>\r\n </p>\r\n <p style="margin:0 0 1em;padding:0;">\r\n \r\n </p>\r\n <p style="margin:0 0 1em;padding:0;">\r\n To login please go to <i><a href="http://{APP_HOST}/#/login">{APP_HOST}/#/login</a></i>\r\n </p>\r\n <p style="margin:0 0 1em;padding:0;">\r\n To reset your pin please go to <i><a href="http://{APP_HOST}/#/forgot">{APP_HOST}/#/forgot</a></i>\r\n </p>\r\n <p style="margin:0 0 1em;padding:0;">\r\n We look forward to interacting with you online,<br/>\r\n The Bid4Cars Team\r\n </p>\r\n </td>\r\n <!-- Spacing Column -->\r\n <td width="40" valign="top" style="width:40px;"> </td>\r\n <!-- Side Column -->\r\n <td width="300" valign="top" style="width:300px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <img src="http://{APP_HOST}/images/handshake.png" width="300px" alt="Content Image" align="left" style="padding:5px;" />\r\n <h2 style="font-size:18px;margin:20px 3px 0px;padding:0;font-weight:400;">Welcome</h2>\r\n <p style="margin:0 0 1em;padding:5px;">\r\n Online technology bringing buyers and sellers\r\n together through the Dealer Network.\r\n </p>\r\n </td>\r\n <!-- Spacing Column -->\r\n <td width="20" valign="top" style="width:20px;"> </td>\r\n </tr>\r\n </table>\r\n <!-- /Main Content Table -->\r\n </td>\r\n </tr>\r\n <tr>\r\n <td style="background:#ececec;padding:10px 0 0;">\r\n <!-- Begin Footer table -->\r\n <table border="0" cellspacing="0" cellpadding="0" width="600" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:600px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <tr>\r\n <!-- Spacing Column -->\r\n <td width="20" valign="top" style="width:20px;"> </td>\r\n <!-- Main Column -->\r\n <td width="560" valign="top" style="width:560px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <p style="margin:0 0 1em;padding:0;"><b>{APP_HOST}</b></p>\r\n </td>\r\n <!-- Spacing Column -->\r\n <td width="20" valign="top" style="width:20px;"> </td>\r\n </tr>\r\n </table>\r\n <!-- /End Footer Table -->\r\n </td>\r\n </tr>\r\n </table>\r\n <!-- /End Main Template Table -->\r\n </td>\r\n </tr>\r\n </table>\r\n<!-- /End 100% Wrapping Table -->\r\n</body>\r\n</html>\r\n', ''),
(23, NULL, 'new-profile-recipient', 'Profile created/updated', 'firstName,familyName,email,pin', '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"\r\n "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">\r\n<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">\r\n<head>\r\n <meta http-equiv="Content-type" content="text/html; charset=utf-8" />\r\n <title></title>\r\n</head>\r\n<body style="padding:0;margin:0;">\r\n <!-- Begin 100% Wrapping Table -->\r\n <table border="0" cellspacing="0" cellpadding="0" width="100%" align="center" style="margin:0; padding:0;border-collapse:collapse; border-spacing:0;width:100%;">\r\n <tr>\r\n <td style="padding:20px 0;">\r\n <!-- Begin Main Template Table -->\r\n <table border="0" cellspacing="0" cellpadding="0" width="800" align="center" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px; margin:0 auto; line-height:1.33;">\r\n <tr>\r\n <td>\r\n <img src="{APP_HOST}/images/EmailHeader.png" width="800" height="100" alt="Please set images to always display for our emails" style="display:block;" />\r\n </td>\r\n </tr>\r\n <tr>\r\n <td style="background:#f6f6f6;padding:20px 0">\r\n <!-- Main Content table -->\r\n <table border="0" cellspacing="0" cellpadding="0" width="800" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <tr>\r\n <!-- Spacing Column -->\r\n <td width="20" valign="top" style="width:20px;"> </td>\r\n <!-- Main Column -->\r\n <td width="420" valign="top" style="width:420px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <h1 style="font-size:18px;margin:0 0 0.5em;padding:0;font-weight:400;">Profile created/updated</h1>\r\n <p style="margin:0 0 1em;padding:0;">\r\n \r\n </p>\r\n <p style="margin:0 0 1em;padding:0;">\r\n Dear [firstName] [familyName],\r\n </p>\r\n <p style="margin:0 0 1em;padding:0;">\r\n A profile was registered/updated for you on the Bid4Cars website.\r\n Here are your login details:\r\n <table border="0" cellspacing="0" cellpadding="3px" width="420" style="border-collapse:collapse; border-spacing:0; margin:0; padding:3px; width:420px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <tr>\r\n <td width="80px"><b>Username:</b></td>\r\n <td><b>[email]</b></td>\r\n </tr>\r\n <tr>\r\n <td><b>Pin:</b></td>\r\n <td><b>[pin]</b></td>\r\n </tr>\r\n </table>\r\n </p>\r\n <p style="margin:0 0 1em;padding:0;">\r\n \r\n </p>\r\n <p style="margin:0 0 1em;padding:0;">\r\n To login please go to <i><a href="http://{APP_HOST}/#/login">{APP_HOST}/#/login</a></i>\r\n </p>\r\n <p style="margin:0 0 1em;padding:0;">\r\n To reset your pin please go to <i><a href="http://{APP_HOST}/#/forgot">{APP_HOST}/#/forgot</a></i>\r\n </p>\r\n <p style="margin:0 0 1em;padding:0;">\r\n And to help you get going please have a look at the FAQ''s <i><a href="http://{APP_HOST}/#/faq">{APP_HOST}/#/index/faq</a></i>\r\n </p>\r\n <p style="margin:0 0 1em;padding:0;">\r\n Regards,<br/>\r\n The Bid4Cars Team\r\n </p>\r\n </td>\r\n <!-- Spacing Column -->\r\n <td width="40" valign="top" style="width:40px;"> </td>\r\n <!-- Side Column -->\r\n <td width="300" valign="top" style="width:300px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <img src="http://{APP_HOST}/images/handshake.png" width="300px" alt="Content Image" align="left" style="padding:5px;" />\r\n <h2 style="font-size:18px;margin:20px 3px 0px;padding:0;font-weight:400;">Welcome</h2>\r\n <p style="margin:0 0 1em;padding:5px;">\r\n Online technology bringing buyers and sellers\r\n together through the Dealer Network.\r\n </p>\r\n </td>\r\n <!-- Spacing Column -->\r\n <td width="20" valign="top" style="width:20px;"> </td>\r\n </tr>\r\n </table>\r\n <!-- /Main Content Table -->\r\n </td>\r\n </tr>\r\n <tr>\r\n <td style="background:#ececec;padding:10px 0 0;">\r\n <!-- Begin Footer table -->\r\n <table border="0" cellspacing="0" cellpadding="0" width="600" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:600px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <tr>\r\n <!-- Spacing Column -->\r\n <td width="20" valign="top" style="width:20px;"> </td>\r\n <!-- Main Column -->\r\n <td width="560" valign="top" style="width:560px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <p style="margin:0 0 1em;padding:0;"><b>{APP_HOST}</b></p>\r\n </td>\r\n <!-- Spacing Column -->\r\n <td width="20" valign="top" style="width:20px;"> </td>\r\n </tr>\r\n </table>\r\n <!-- /End Footer Table -->\r\n </td>\r\n </tr>\r\n </table>\r\n <!-- /End Main Template Table -->\r\n </td>\r\n </tr>\r\n </table>\r\n<!-- /End 100% Wrapping Table -->\r\n</body>\r\n</html>\r\n', ''),
(24, NULL, 'new-profile-admin-notification', 'Profile created/updated by user', 'firstName,familyName,company.firstName,company.familyName,profile.name,company.name,profile.familyName,email', '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"\r\n "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">\r\n<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">\r\n<head>\r\n <meta http-equiv="Content-type" content="text/html; charset=utf-8" />\r\n <title></title>\r\n</head>\r\n<body style="padding:0;margin:0;">\r\n <!-- Begin 100% Wrapping Table -->\r\n <table border="0" cellspacing="0" cellpadding="0" width="100%" align="center" style="margin:0; padding:0;border-collapse:collapse; border-spacing:0;width:100%;">\r\n <tr>\r\n <td style="padding:20px 0;">\r\n <!-- Begin Main Template Table -->\r\n <table border="0" cellspacing="0" cellpadding="0" width="800" align="center" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px; margin:0 auto; line-height:1.33;">\r\n <tr>\r\n <td>\r\n <img src="{APP_HOST}/images/EmailHeader.png" width="800" height="100" alt="Please set images to always display for our emails" style="display:block;" />\r\n </td>\r\n </tr>\r\n <tr>\r\n <td style="background:#f6f6f6;padding:20px 0">\r\n <!-- Main Content table -->\r\n <table border="0" cellspacing="0" cellpadding="0" width="800" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <tr>\r\n <!-- Spacing Column -->\r\n <td width="20" valign="top" style="width:20px;"> </td>\r\n <!-- Main Column -->\r\n <td width="420" valign="top" style="width:420px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <h1 style="font-size:18px;margin:0 0 0.5em;padding:0;font-weight:400;">Profile created/updated</h1>\r\n <p style="margin:0 0 1em;padding:0;">\r\n \r\n </p>\r\n <p style="margin:0 0 1em;padding:0;">\r\n Dear [firstName] [familyName],\r\n </p>\r\n <p style="margin:0 0 1em;padding:0;">\r\n [company.firstName] [company.familyName] from [company.name] has just registered/updated a profile for:\r\n <table border="0" cellspacing="0" cellpadding="3px" width="420" style="border-collapse:collapse; border-spacing:0; margin:0; padding:3px; width:420px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <tr>\r\n <td width="80px"><b>Name:</b></td>\r\n <td><b>[profile.name]</b></td>\r\n </tr>\r\n <tr>\r\n <td width="80px"><b>Family name:</b></td>\r\n <td><b>[profile.familyName]</b></td>\r\n </tr>\r\n <tr>\r\n <td width="80px"><b>Username:</b></td>\r\n <td><b>[email]</b></td>\r\n </tr>\r\n </table>\r\n </p>\r\n <p style="margin:0 0 1em;padding:0;">\r\n \r\n </p>\r\n <p style="margin:0 0 1em;padding:0;">\r\n To login please go to <i><a href="http://{APP_HOST}/#/login">{APP_HOST}/#/login</a></i>\r\n </p>\r\n <p style="margin:0 0 1em;padding:0;">\r\n To reset your pin please go to <i><a href="http://{APP_HOST}/#/forgot">{APP_HOST}/#/forgot</a></i>\r\n </p>\r\n <p style="margin:0 0 1em;padding:0;">\r\n And to help you get going please have a look at the FAQ''s <i><a href="http://{APP_HOST}/index/faq">{APP_HOST}/index/faq</a></i>\r\n </p>\r\n <p style="margin:0 0 1em;padding:0;">\r\n Regards,<br/>\r\n The Bid4Cars Team\r\n </p>\r\n </td>\r\n <!-- Spacing Column -->\r\n <td width="40" valign="top" style="width:40px;"> </td>\r\n <!-- Side Column -->\r\n <td width="300" valign="top" style="width:300px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <img src="http://{APP_HOST}/images/handshake.png" width="300px" alt="Content Image" align="left" style="padding:5px;" />\r\n <h2 style="font-size:18px;margin:20px 3px 0px;padding:0;font-weight:400;">Welcome</h2>\r\n <p style="margin:0 0 1em;padding:5px;">\r\n Online technology bringing buyers and sellers\r\n together through the Dealer Network.\r\n </p>\r\n </td>\r\n <!-- Spacing Column -->\r\n <td width="20" valign="top" style="width:20px;"> </td>\r\n </tr>\r\n </table>\r\n <!-- /Main Content Table -->\r\n </td>\r\n </tr>\r\n <tr>\r\n <td style="background:#ececec;padding:10px 0 0;">\r\n <!-- Begin Footer table -->\r\n <table border="0" cellspacing="0" cellpadding="0" width="600" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:600px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <tr>\r\n <!-- Spacing Column -->\r\n <td width="20" valign="top" style="width:20px;"> </td>\r\n <!-- Main Column -->\r\n <td width="560" valign="top" style="width:560px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <p style="margin:0 0 1em;padding:0;"><b>{APP_HOST}</b></p>\r\n </td>\r\n <!-- Spacing Column -->\r\n <td width="20" valign="top" style="width:20px;"> </td>\r\n </tr>\r\n </table>\r\n <!-- /End Footer Table -->\r\n </td>\r\n </tr>\r\n </table>\r\n <!-- /End Main Template Table -->\r\n </td>\r\n </tr>\r\n </table>\r\n<!-- /End 100% Wrapping Table -->\r\n</body>\r\n</html>\r\n', ''),
-(25, NULL, 'new-vehicle', 'New vehicle added', 'firstName,familyName,vehicle', '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"\r\n "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">\r\n<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">\r\n<head>\r\n <meta http-equiv="Content-type" content="text/html; charset=utf-8" />\r\n <title></title>\r\n</head>\r\n<body style="padding:0;margin:0;">\r\n <!-- Begin 100% Wrapping Table -->\r\n <table border="0" cellspacing="0" cellpadding="0" width="100%" align="center" style="margin:0; padding:0;border-collapse:collapse; border-spacing:0;width:100%;">\r\n <tr>\r\n <td style="padding:20px 0;">\r\n <!-- Begin Main Template Table --> \r\n <table border="0" cellspacing="0" cellpadding="0" width="800" align="center" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px; margin:0 auto; line-height:1.33;">\r\n <tr>\r\n <td>\r\n <img src="{APP_HOST}/images/EmailHeader.png" width="800" height="100" alt="Please set images to always display for our emails" style="display:block;" />\r\n </td>\r\n </tr> \r\n <tr>\r\n <td style="background:#f6f6f6;padding:20px 0">\r\n <!-- Main Content table -->\r\n <table border="0" cellspacing="0" cellpadding="0" width="800" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <tr>\r\n <!-- Spacing Column -->\r\n <td width="20" valign="top" style="width:20px;"> </td>\r\n <!-- Main Column -->\r\n <td width="420" valign="top" style="width:420px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <h1 style="font-size:18px;margin:0 0 0.5em;padding:0;font-weight:400;">New vehicle added</h1>\r\n <p style="margin:0 0 1em;padding:0;">\r\n \r\n </p>\r\n <p style="margin:0 0 1em;padding:0;">\r\n Dear [firstName] [familyName],\r\n </p>\r\n <p style="margin:0 0 1em;padding:0;">\r\n A new vehicle, [vehicle], was just added to the system. Please see the attachment for vehicle details.\r\n </p>\r\n <p style="margin:0 0 1em;padding:0;">\r\n Regards,<br/>\r\n The Bid4Cars Team\r\n </p>\r\n </td>\r\n <!-- Spacing Column -->\r\n <td width="40" valign="top" style="width:40px;"> </td>\r\n <!-- Side Column -->\r\n <td width="300" valign="top" style="width:300px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <img src="http://{APP_HOST}/images/handshake.png" width="300px" alt="Content Image" align="left" style="padding:5px;" />\r\n <h2 style="font-size:18px;margin:20px 3px 0px;padding:0;font-weight:400;">Auctions</h2>\r\n <p style="margin:0 0 1em;padding:5px;">\r\n Online technology bringing buyers and sellers\r\n together through the Dealer Network.\r\n </p> \r\n </td>\r\n <!-- Spacing Column -->\r\n <td width="20" valign="top" style="width:20px;"> </td>\r\n </tr>\r\n </table>\r\n <!-- /Main Content Table --> \r\n </td> \r\n </tr>\r\n <tr>\r\n <td style="background:#ececec;padding:10px 0 0;">\r\n <!-- Begin Footer table -->\r\n <table border="0" cellspacing="0" cellpadding="0" width="800" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <tr>\r\n <!-- Spacing Column -->\r\n <td width="20" valign="top" style="width:20px;"> </td>\r\n <!-- Main Column -->\r\n <td width="380" valign="top" style="width:380px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <p style="margin:0 0 1em;padding:0;"><b>bid4cars.co.za</b></p>\r\n </td>\r\n <!-- Spacing Column --> \r\n <td width="380" valign="top" align="right" style="width:380px;">\r\n Click <a href="http://{APP_HOST}/unsubscribe/reminder">here</a> to unsubscribe from reminders.\r\n </td>\r\n <!-- Spacing Column -->\r\n <td width="20" valign="top" style="width:20px;"> </td>\r\n </tr>\r\n </table>\r\n <!-- /End Footer Table -->\r\n </td>\r\n </tr>\r\n </table>\r\n <!-- /End Main Template Table -->\r\n </td>\r\n </tr>\r\n </table>\r\n<!-- /End 100% Wrapping Table --> \r\n</body>\r\n</html>\r\n', ''),
-(26, NULL, 'newsletter-basic', 'Bid4cars newsletter', 'headerImageSource,body,footerImageSource', '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"\r\n "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">\r\n<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">\r\n<head>\r\n <meta http-equiv="Content-type" content="text/html; charset=utf-8" />\r\n <title></title>\r\n</head>\r\n<body style="padding:0;margin:0;">\r\n <!-- Begin 100% Wrapping Table -->\r\n <table border="0" cellspacing="0" cellpadding="0" width="100%" align="center" style="margin:0; padding:0;border-collapse:collapse; border-spacing:0;width:100%;">\r\n <tr>\r\n <td style="padding:20px 0;">\r\n <!-- Begin Main Template Table --> \r\n <table border="0" cellspacing="0" cellpadding="0" width="800" align="center" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px; margin:0 auto; line-height:1.33;">\r\n <tr>\r\n <td>\r\n <img src="{APP_HOST}/images/EmailHeader.png" width="800" height="100" alt="Please set images to always display for our emails" style="display:block;" />\r\n </td>\r\n </tr> \r\n <tr>\r\n <td style="background:#f6f6f6;padding:20px 0">\r\n <!-- Main Content table -->\r\n <table border="0" cellspacing="0" cellpadding="0" width="800" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <tr>\r\n <!-- Spacing Column -->\r\n <td width="20" valign="top" style="width:20px;"> </td>\r\n <!-- Main Column -->\r\n <td width="420" valign="top" style="width:420px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <h1 style="font-size:18px;margin:0 0 0.5em;padding:0;font-weight:400;">New vehicle added</h1>\r\n <p style="margin:0 0 1em;padding:0;">\r\n \r\n </p>\r\n <p style="margin:0 0 1em;padding:0;">\r\n Dear [firstName] [familyName],\r\n </p>\r\n <p style="margin:0 0 1em;padding:0;">\r\n A new vehicle, [vehicle], was just added to the system. Please see the attachment for vehicle details.\r\n </p>\r\n <p style="margin:0 0 1em;padding:0;">\r\n Regards,<br/>\r\n The Bid4Cars Team\r\n </p>\r\n </td>\r\n <!-- Spacing Column -->\r\n <td width="40" valign="top" style="width:40px;"> </td>\r\n <!-- Side Column -->\r\n <td width="300" valign="top" style="width:300px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <img src="http://{APP_HOST}/images/handshake.png" width="300px" alt="Content Image" align="left" style="padding:5px;" />\r\n <h2 style="font-size:18px;margin:20px 3px 0px;padding:0;font-weight:400;">Auctions</h2>\r\n <p style="margin:0 0 1em;padding:5px;">\r\n Online technology bringing buyers and sellers\r\n together through the Dealer Network.\r\n </p> \r\n </td>\r\n <!-- Spacing Column -->\r\n <td width="20" valign="top" style="width:20px;"> </td>\r\n </tr>\r\n </table>\r\n <!-- /Main Content Table --> \r\n </td> \r\n </tr>\r\n <tr>\r\n <td style="background:#ececec;padding:10px 0 0;">\r\n <!-- Begin Footer table -->\r\n <table border="0" cellspacing="0" cellpadding="0" width="800" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <tr>\r\n <!-- Spacing Column -->\r\n <td width="20" valign="top" style="width:20px;"> </td>\r\n <!-- Main Column -->\r\n <td width="380" valign="top" style="width:380px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <p style="margin:0 0 1em;padding:0;"><b>bid4cars.co.za</b></p>\r\n </td>\r\n <!-- Spacing Column --> \r\n <td width="380" valign="top" align="right" style="width:380px;">\r\n Click <a href="http://{APP_HOST}/unsubscribe/reminder">here</a> to unsubscribe from reminders.\r\n </td>\r\n <!-- Spacing Column -->\r\n <td width="20" valign="top" style="width:20px;"> </td>\r\n </tr>\r\n </table>\r\n <!-- /End Footer Table -->\r\n </td>\r\n </tr>\r\n </table>\r\n <!-- /End Main Template Table -->\r\n </td>\r\n </tr>\r\n </table>\r\n<!-- /End 100% Wrapping Table --> \r\n</body>\r\n</html>\r\n', ''),
-(27, NULL, 'new-dispute', 'New Dispute Logged', 'plaintive,defendant,vehicle,reference_number,registration_number,complaint,plaintive_contact,plaintive_telephone,plaintive_mobile,plaintive_email,defendant_contact,defendant_telephone,defendant_mobile,defendant_email', '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"\r\n "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">\r\n<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">\r\n<head>\r\n <meta http-equiv="Content-type" content="text/html; charset=utf-8" />\r\n <title></title>\r\n</head>\r\n<body style="padding:0;margin:0;">\r\n <!-- Begin 100% Wrapping Table -->\r\n <table border="0" cellspacing="0" cellpadding="0" width="100%" align="center" style="margin:0; padding:0;border-collapse:collapse; border-spacing:0;width:100%;">\r\n <tr>\r\n <td style="padding:20px 0;">\r\n <!-- Begin Main Template Table --> \r\n <table border="0" cellspacing="0" cellpadding="0" width="800" align="center" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px; margin:0 auto; line-height:1.33;">\r\n <tr>\r\n <td>\r\n <img src="http://{APP_HOST}/images/EmailHeader.png" width="800" height="100" alt="Please set images to always display for our emails" style="display:block;" />\r\n </td>\r\n </tr>\r\n <tr>\r\n <td style="background:#f6f6f6;padding:20px 0 0 0">\r\n <!-- Main Content table -->\r\n <table border="0" cellspacing="0" cellpadding="0" width="800" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <tr>\r\n <!-- Spacing Column -->\r\n <td width="20" valign="top" style="width:20px;"> </td>\r\n <!-- Main Column -->\r\n <td width="760" valign="top" style="width:760px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <h1 style="font-size:18px;margin:0 0 0.5em;padding:0;font-weight:400;">New Dispute Logged</h1>\r\n <p style="margin:0 0 1em;padding:0;">\r\n A dispute has been logged by [plaintive] against [defendant]\r\n concerning the purchase of [vehicle]. \r\n </p>\r\n <p style="margin:0 0 1em;padding:0;">\r\n <table border="0" cellspacing="0" cellpadding="3px" width="420" style="border-collapse:collapse; border-spacing:0; margin:0; padding:3px; width:420px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <tr>\r\n <td width="120px"><b>B4C reference:</b></td>\r\n <td>[reference_number]</td>\r\n </tr>\r\n <tr>\r\n <td><b>Vehicle:</b></td>\r\n <td>[vehicle]</td>\r\n </tr>\r\n <tr>\r\n <td><b>Vehicle Registration:</b></td>\r\n <td>[registration_number]</td>\r\n </tr>\r\n </table>\r\n </p>\r\n </td>\r\n <!-- Spacing Column -->\r\n <td width="20" valign="top" style="width:20px;"> </td>\r\n </tr>\r\n </table>\r\n <!-- /Main Content Table --> \r\n </td> \r\n </tr>\r\n <tr>\r\n <td style="background:#f6f6f6;padding:10px 0">\r\n <!-- Main Content table -->\r\n <table border="0" cellspacing="5px" cellpadding="0" width="800" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <tr>\r\n <!-- Spacing Column -->\r\n <td width="20" valign="top" style="width:20px;"> </td>\r\n <!-- Main Column -->\r\n <td width="330" valign="top" style="background:#c6c6c6; padding:15px; width:330px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <h1 style="font-size:18px;margin:0 0 0.5em;padding:0;font-weight:400;">Plaintive: [plaintive]</h1>\r\n <p style="margin:0 0 1em;padding:0;">\r\n <table border="0" cellspacing="0" cellpadding="3px" width="330" style="border-collapse:collapse; border-spacing:0; margin:0; padding:3px; width:330px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <tr>\r\n <td width="110px"><b>Contact Person:</b></td>\r\n <td>[plaintive_contact]</td>\r\n </tr>\r\n <tr>\r\n <td><b>Telephone number:</b></td>\r\n <td>[plaintive_telephone]</td>\r\n </tr>\r\n <tr>\r\n <td><b>Mobile number:</b></td>\r\n <td>[plaintive_mobile]</td>\r\n </tr>\r\n <tr>\r\n <td><b>Email address:</b></td>\r\n <td>[plaintive_email]</td>\r\n </tr>\r\n </table>\r\n </p>\r\n </td>\r\n <!-- Spacing Column -->\r\n <td width="40" valign="top" style="width:40px;"> </td>\r\n <!-- Main Column -->\r\n <td width="330" valign="top" style="background:#c6c6c6; padding:15px; width:330px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <h1 style="font-size:18px;margin:0 0 0.5em;padding:0;font-weight:400;">Defendant: [defendant]</h1>\r\n <p style="margin:0 0 1em;padding:0;">\r\n <table border="0" cellspacing="0" cellpadding="3px" width="330" style="border-collapse:collapse; border-spacing:0; margin:0; padding:3px; width:330px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <tr>\r\n <td width="110px"><b>Contact Person:</b></td>\r\n <td>[defendant_contact]</td>\r\n </tr>\r\n <tr>\r\n <td><b>Telephone number:</b></td>\r\n <td>[defendant_telephone]</td>\r\n </tr>\r\n <tr>\r\n <td><b>Mobile number:</b></td>\r\n <td>[defendant_mobile]</td>\r\n </tr>\r\n <tr>\r\n <td><b>Email address:</b></td>\r\n <td>[defendant_email]</td>\r\n </tr>\r\n </table>\r\n </p>\r\n </td>\r\n <!-- Spacing Column -->\r\n <td width="20" valign="top" style="width:20px;"> </td>\r\n </tr>\r\n </table>\r\n <!-- /Main Content Table --> \r\n </td> \r\n </tr>\r\n <tr>\r\n <td style="background:#f6f6f6;padding:10px 0">\r\n <table border="0" cellspacing="0" cellpadding="0" width="800" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <tr>\r\n <!-- Spacing Column -->\r\n <td width="20" valign="top" style="width:20px;"> </td>\r\n <!-- Main Column -->\r\n <td width="760" valign="top" style="width:760px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <h2 style="font-size:18px;margin:0 0 0.5em;padding:0;font-weight:400;">Complaint</h2>\r\n <p style="margin:0 0 1em;padding:0;">\r\n [complaint]\r\n </p>\r\n </td>\r\n <!-- Spacing Column -->\r\n <td width="20" valign="top" style="width:20px;"> </td>\r\n </tr>\r\n </table>\r\n </td> \r\n </tr>\r\n <tr>\r\n <td style="background:#ececec;padding:10px 0 0;">\r\n <!-- Begin Footer table -->\r\n <table border="0" cellspacing="0" cellpadding="0" width="600" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:600px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <tr>\r\n <!-- Spacing Column -->\r\n <td width="20" valign="top" style="width:20px;"> </td>\r\n <!-- Main Column -->\r\n <td width="560" valign="top" style="width:560px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <p style="margin:0 0 1em;padding:0;"><b>bid4cars.co.za</b></p>\r\n </td>\r\n <!-- Spacing Column --> \r\n <td width="20" valign="top" style="width:20px;"> </td>\r\n </tr>\r\n </table>\r\n <!-- /End Footer Table --> \r\n </td>\r\n </tr> \r\n </table>\r\n <!-- /End Main Template Table -->\r\n </td>\r\n </tr>\r\n </table>\r\n<!-- /End 100% Wrapping Table --> \r\n</body>\r\n</html>\r\n', '');
+(25, NULL, 'new-vehicle', 'New vehicle added', 'firstName,familyName,vehicle', '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"\r\n "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">\r\n<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">\r\n<head>\r\n <meta http-equiv="Content-type" content="text/html; charset=utf-8" />\r\n <title></title>\r\n</head>\r\n<body style="padding:0;margin:0;">\r\n <!-- Begin 100% Wrapping Table -->\r\n <table border="0" cellspacing="0" cellpadding="0" width="100%" align="center" style="margin:0; padding:0;border-collapse:collapse; border-spacing:0;width:100%;">\r\n <tr>\r\n <td style="padding:20px 0;">\r\n <!-- Begin Main Template Table --> \r\n <table border="0" cellspacing="0" cellpadding="0" width="800" align="center" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px; margin:0 auto; line-height:1.33;">\r\n <tr>\r\n <td>\r\n <img src="{APP_HOST}/images/EmailHeader.png" width="800" height="100" alt="Please set images to always display for our emails" style="display:block;" />\r\n </td>\r\n </tr> \r\n <tr>\r\n <td style="background:#f6f6f6;padding:20px 0">\r\n <!-- Main Content table -->\r\n <table border="0" cellspacing="0" cellpadding="0" width="800" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <tr>\r\n <!-- Spacing Column -->\r\n <td width="20" valign="top" style="width:20px;"> </td>\r\n <!-- Main Column -->\r\n <td width="420" valign="top" style="width:420px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <h1 style="font-size:18px;margin:0 0 0.5em;padding:0;font-weight:400;">New vehicle added</h1>\r\n <p style="margin:0 0 1em;padding:0;">\r\n \r\n </p>\r\n <p style="margin:0 0 1em;padding:0;">\r\n Dear [firstName] [familyName],\r\n </p>\r\n <p style="margin:0 0 1em;padding:0;">\r\n A new vehicle, [vehicle], was just added to the system. Please see the attachment for vehicle details.\r\n </p>\r\n <p style="margin:0 0 1em;padding:0;">\r\n Regards,<br/>\r\n The Bid4Cars Team\r\n </p>\r\n </td>\r\n <!-- Spacing Column -->\r\n <td width="40" valign="top" style="width:40px;"> </td>\r\n <!-- Side Column -->\r\n <td width="300" valign="top" style="width:300px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <img src="http://{APP_HOST}/images/handshake.png" width="300px" alt="Content Image" align="left" style="padding:5px;" />\r\n <h2 style="font-size:18px;margin:20px 3px 0px;padding:0;font-weight:400;">Auctions</h2>\r\n <p style="margin:0 0 1em;padding:5px;">\r\n Online technology bringing buyers and sellers\r\n together through the Dealer Network.\r\n </p> \r\n </td>\r\n <!-- Spacing Column -->\r\n <td width="20" valign="top" style="width:20px;"> </td>\r\n </tr>\r\n </table>\r\n <!-- /Main Content Table --> \r\n </td> \r\n </tr>\r\n <tr>\r\n <td style="background:#ececec;padding:10px 0 0;">\r\n <!-- Begin Footer table -->\r\n <table border="0" cellspacing="0" cellpadding="0" width="800" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <tr>\r\n <!-- Spacing Column -->\r\n <td width="20" valign="top" style="width:20px;"> </td>\r\n <!-- Main Column -->\r\n <td width="380" valign="top" style="width:380px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <p style="margin:0 0 1em;padding:0;"><b>bid4cars.com.na</b></p>\r\n </td>\r\n <!-- Spacing Column --> \r\n <td width="380" valign="top" align="right" style="width:380px;">\r\n Click <a href="http://{APP_HOST}/unsubscribe/reminder">here</a> to unsubscribe from reminders.\r\n </td>\r\n <!-- Spacing Column -->\r\n <td width="20" valign="top" style="width:20px;"> </td>\r\n </tr>\r\n </table>\r\n <!-- /End Footer Table -->\r\n </td>\r\n </tr>\r\n </table>\r\n <!-- /End Main Template Table -->\r\n </td>\r\n </tr>\r\n </table>\r\n<!-- /End 100% Wrapping Table --> \r\n</body>\r\n</html>\r\n', ''),
+(26, NULL, 'newsletter-basic', 'Bid4cars newsletter', 'headerImageSource,body,footerImageSource', '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"\r\n "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">\r\n<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">\r\n<head>\r\n <meta http-equiv="Content-type" content="text/html; charset=utf-8" />\r\n <title></title>\r\n</head>\r\n<body style="padding:0;margin:0;">\r\n <!-- Begin 100% Wrapping Table -->\r\n <table border="0" cellspacing="0" cellpadding="0" width="100%" align="center" style="margin:0; padding:0;border-collapse:collapse; border-spacing:0;width:100%;">\r\n <tr>\r\n <td style="padding:20px 0;">\r\n <!-- Begin Main Template Table --> \r\n <table border="0" cellspacing="0" cellpadding="0" width="800" align="center" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px; margin:0 auto; line-height:1.33;">\r\n <tr>\r\n <td>\r\n <img src="{APP_HOST}/images/EmailHeader.png" width="800" height="100" alt="Please set images to always display for our emails" style="display:block;" />\r\n </td>\r\n </tr> \r\n <tr>\r\n <td style="background:#f6f6f6;padding:20px 0">\r\n <!-- Main Content table -->\r\n <table border="0" cellspacing="0" cellpadding="0" width="800" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <tr>\r\n <!-- Spacing Column -->\r\n <td width="20" valign="top" style="width:20px;"> </td>\r\n <!-- Main Column -->\r\n <td width="420" valign="top" style="width:420px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <h1 style="font-size:18px;margin:0 0 0.5em;padding:0;font-weight:400;">New vehicle added</h1>\r\n <p style="margin:0 0 1em;padding:0;">\r\n \r\n </p>\r\n <p style="margin:0 0 1em;padding:0;">\r\n Dear [firstName] [familyName],\r\n </p>\r\n <p style="margin:0 0 1em;padding:0;">\r\n A new vehicle, [vehicle], was just added to the system. Please see the attachment for vehicle details.\r\n </p>\r\n <p style="margin:0 0 1em;padding:0;">\r\n Regards,<br/>\r\n The Bid4Cars Team\r\n </p>\r\n </td>\r\n <!-- Spacing Column -->\r\n <td width="40" valign="top" style="width:40px;"> </td>\r\n <!-- Side Column -->\r\n <td width="300" valign="top" style="width:300px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <img src="http://{APP_HOST}/images/handshake.png" width="300px" alt="Content Image" align="left" style="padding:5px;" />\r\n <h2 style="font-size:18px;margin:20px 3px 0px;padding:0;font-weight:400;">Auctions</h2>\r\n <p style="margin:0 0 1em;padding:5px;">\r\n Online technology bringing buyers and sellers\r\n together through the Dealer Network.\r\n </p> \r\n </td>\r\n <!-- Spacing Column -->\r\n <td width="20" valign="top" style="width:20px;"> </td>\r\n </tr>\r\n </table>\r\n <!-- /Main Content Table --> \r\n </td> \r\n </tr>\r\n <tr>\r\n <td style="background:#ececec;padding:10px 0 0;">\r\n <!-- Begin Footer table -->\r\n <table border="0" cellspacing="0" cellpadding="0" width="800" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <tr>\r\n <!-- Spacing Column -->\r\n <td width="20" valign="top" style="width:20px;"> </td>\r\n <!-- Main Column -->\r\n <td width="380" valign="top" style="width:380px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <p style="margin:0 0 1em;padding:0;"><b>bid4cars.com.na</b></p>\r\n </td>\r\n <!-- Spacing Column --> \r\n <td width="380" valign="top" align="right" style="width:380px;">\r\n Click <a href="http://{APP_HOST}/unsubscribe/reminder">here</a> to unsubscribe from reminders.\r\n </td>\r\n <!-- Spacing Column -->\r\n <td width="20" valign="top" style="width:20px;"> </td>\r\n </tr>\r\n </table>\r\n <!-- /End Footer Table -->\r\n </td>\r\n </tr>\r\n </table>\r\n <!-- /End Main Template Table -->\r\n </td>\r\n </tr>\r\n </table>\r\n<!-- /End 100% Wrapping Table --> \r\n</body>\r\n</html>\r\n', ''),
+(27, NULL, 'new-dispute', 'New Dispute Logged', 'plaintive,defendant,vehicle,reference_number,registration_number,complaint,plaintive_contact,plaintive_telephone,plaintive_mobile,plaintive_email,defendant_contact,defendant_telephone,defendant_mobile,defendant_email', '<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"\r\n "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">\r\n<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">\r\n<head>\r\n <meta http-equiv="Content-type" content="text/html; charset=utf-8" />\r\n <title></title>\r\n</head>\r\n<body style="padding:0;margin:0;">\r\n <!-- Begin 100% Wrapping Table -->\r\n <table border="0" cellspacing="0" cellpadding="0" width="100%" align="center" style="margin:0; padding:0;border-collapse:collapse; border-spacing:0;width:100%;">\r\n <tr>\r\n <td style="padding:20px 0;">\r\n <!-- Begin Main Template Table --> \r\n <table border="0" cellspacing="0" cellpadding="0" width="800" align="center" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px; margin:0 auto; line-height:1.33;">\r\n <tr>\r\n <td>\r\n <img src="http://{APP_HOST}/images/EmailHeader.png" width="800" height="100" alt="Please set images to always display for our emails" style="display:block;" />\r\n </td>\r\n </tr>\r\n <tr>\r\n <td style="background:#f6f6f6;padding:20px 0 0 0">\r\n <!-- Main Content table -->\r\n <table border="0" cellspacing="0" cellpadding="0" width="800" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <tr>\r\n <!-- Spacing Column -->\r\n <td width="20" valign="top" style="width:20px;"> </td>\r\n <!-- Main Column -->\r\n <td width="760" valign="top" style="width:760px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <h1 style="font-size:18px;margin:0 0 0.5em;padding:0;font-weight:400;">New Dispute Logged</h1>\r\n <p style="margin:0 0 1em;padding:0;">\r\n A dispute has been logged by [plaintive] against [defendant]\r\n concerning the purchase of [vehicle]. \r\n </p>\r\n <p style="margin:0 0 1em;padding:0;">\r\n <table border="0" cellspacing="0" cellpadding="3px" width="420" style="border-collapse:collapse; border-spacing:0; margin:0; padding:3px; width:420px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <tr>\r\n <td width="120px"><b>B4C reference:</b></td>\r\n <td>[reference_number]</td>\r\n </tr>\r\n <tr>\r\n <td><b>Vehicle:</b></td>\r\n <td>[vehicle]</td>\r\n </tr>\r\n <tr>\r\n <td><b>Vehicle Registration:</b></td>\r\n <td>[registration_number]</td>\r\n </tr>\r\n </table>\r\n </p>\r\n </td>\r\n <!-- Spacing Column -->\r\n <td width="20" valign="top" style="width:20px;"> </td>\r\n </tr>\r\n </table>\r\n <!-- /Main Content Table --> \r\n </td> \r\n </tr>\r\n <tr>\r\n <td style="background:#f6f6f6;padding:10px 0">\r\n <!-- Main Content table -->\r\n <table border="0" cellspacing="5px" cellpadding="0" width="800" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <tr>\r\n <!-- Spacing Column -->\r\n <td width="20" valign="top" style="width:20px;"> </td>\r\n <!-- Main Column -->\r\n <td width="330" valign="top" style="background:#c6c6c6; padding:15px; width:330px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <h1 style="font-size:18px;margin:0 0 0.5em;padding:0;font-weight:400;">Plaintive: [plaintive]</h1>\r\n <p style="margin:0 0 1em;padding:0;">\r\n <table border="0" cellspacing="0" cellpadding="3px" width="330" style="border-collapse:collapse; border-spacing:0; margin:0; padding:3px; width:330px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <tr>\r\n <td width="110px"><b>Contact Person:</b></td>\r\n <td>[plaintive_contact]</td>\r\n </tr>\r\n <tr>\r\n <td><b>Telephone number:</b></td>\r\n <td>[plaintive_telephone]</td>\r\n </tr>\r\n <tr>\r\n <td><b>Mobile number:</b></td>\r\n <td>[plaintive_mobile]</td>\r\n </tr>\r\n <tr>\r\n <td><b>Email address:</b></td>\r\n <td>[plaintive_email]</td>\r\n </tr>\r\n </table>\r\n </p>\r\n </td>\r\n <!-- Spacing Column -->\r\n <td width="40" valign="top" style="width:40px;"> </td>\r\n <!-- Main Column -->\r\n <td width="330" valign="top" style="background:#c6c6c6; padding:15px; width:330px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <h1 style="font-size:18px;margin:0 0 0.5em;padding:0;font-weight:400;">Defendant: [defendant]</h1>\r\n <p style="margin:0 0 1em;padding:0;">\r\n <table border="0" cellspacing="0" cellpadding="3px" width="330" style="border-collapse:collapse; border-spacing:0; margin:0; padding:3px; width:330px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <tr>\r\n <td width="110px"><b>Contact Person:</b></td>\r\n <td>[defendant_contact]</td>\r\n </tr>\r\n <tr>\r\n <td><b>Telephone number:</b></td>\r\n <td>[defendant_telephone]</td>\r\n </tr>\r\n <tr>\r\n <td><b>Mobile number:</b></td>\r\n <td>[defendant_mobile]</td>\r\n </tr>\r\n <tr>\r\n <td><b>Email address:</b></td>\r\n <td>[defendant_email]</td>\r\n </tr>\r\n </table>\r\n </p>\r\n </td>\r\n <!-- Spacing Column -->\r\n <td width="20" valign="top" style="width:20px;"> </td>\r\n </tr>\r\n </table>\r\n <!-- /Main Content Table --> \r\n </td> \r\n </tr>\r\n <tr>\r\n <td style="background:#f6f6f6;padding:10px 0">\r\n <table border="0" cellspacing="0" cellpadding="0" width="800" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:800px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <tr>\r\n <!-- Spacing Column -->\r\n <td width="20" valign="top" style="width:20px;"> </td>\r\n <!-- Main Column -->\r\n <td width="760" valign="top" style="width:760px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <h2 style="font-size:18px;margin:0 0 0.5em;padding:0;font-weight:400;">Complaint</h2>\r\n <p style="margin:0 0 1em;padding:0;">\r\n [complaint]\r\n </p>\r\n </td>\r\n <!-- Spacing Column -->\r\n <td width="20" valign="top" style="width:20px;"> </td>\r\n </tr>\r\n </table>\r\n </td> \r\n </tr>\r\n <tr>\r\n <td style="background:#ececec;padding:10px 0 0;">\r\n <!-- Begin Footer table -->\r\n <table border="0" cellspacing="0" cellpadding="0" width="600" style="border-collapse:collapse; border-spacing:0; margin:0; padding:0; width:600px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <tr>\r\n <!-- Spacing Column -->\r\n <td width="20" valign="top" style="width:20px;"> </td>\r\n <!-- Main Column -->\r\n <td width="560" valign="top" style="width:560px; font-family: Arial, Sans-serif; font-size:12px;">\r\n <p style="margin:0 0 1em;padding:0;"><b>bid4cars.com.na</b></p>\r\n </td>\r\n <!-- Spacing Column --> \r\n <td width="20" valign="top" style="width:20px;"> </td>\r\n </tr>\r\n </table>\r\n <!-- /End Footer Table --> \r\n </td>\r\n </tr> \r\n </table>\r\n <!-- /End Main Template Table -->\r\n </td>\r\n </tr>\r\n </table>\r\n<!-- /End 100% Wrapping Table --> \r\n</body>\r\n</html>\r\n', '');
-- --------------------------------------------------------
(6, 2, NULL, NULL, NULL, NULL, 7, 6, 'b@amh.com', 'fbb5c2b460752b3587fb752f96693e72bd087c23', '2c23c7814bb3395149cf3943fd689340f35664d7', 'Sue', 'Jackson', '7001012020006', '1970-01-01', '+27821234567', NULL, 'Dealership User', 'Manager', 1, 1, NULL, 'Active', '2013-08-29 08:22:18', NULL, 0),
(7, 3, NULL, NULL, NULL, NULL, 6, 7, 'a@independant.com', 'd8e1e55e38b9607b67df00354cec27969650c62e', '9bbd7c7bd6f0357045a1b5781753c9575a99c5ea', 'Janine', 'Tweed', '7001012020005', '1970-01-01', '+27821234567', NULL, 'Dealership User', 'Manager', 1, 1, NULL, 'Active', '2013-08-29 08:22:18', NULL, 0),
(8, 3, NULL, NULL, NULL, NULL, 8, 8, 'b@independant.com', 'fa6e73e8ccfdadb61b23387cfe9a2c013bb5f636', '1c82d1f7f53ed74c840299b4566ef7c00d2c186a', 'Some', 'Lady', '7001012020004', '1970-01-01', '+27821234567', NULL, 'Dealership User', 'Manager', 1, 1, NULL, 'Active', '2013-08-29 08:22:18', NULL, 0),
-(9, 4, NULL, NULL, NULL, NULL, 5, 9, 'dave@bid4cars.co.za', '7186b7bf6a4d154f67e1ed832e47c6059dc776f3', '09c462ea3f82833c1a427b4f78e1ac060bba11cd', 'Dave', 'Thomas', '7001012020009', '1970-01-01', '+27833248462', NULL, 'Dealership User', 'Manager', 1, 1, NULL, 'Active', '2013-08-29 08:22:18', NULL, 0),
+(9, 4, NULL, NULL, NULL, NULL, 5, 9, 'dave@bid4cars.com.na', '7186b7bf6a4d154f67e1ed832e47c6059dc776f3', '09c462ea3f82833c1a427b4f78e1ac060bba11cd', 'Dave', 'Thomas', '7001012020009', '1970-01-01', '+27833248462', NULL, 'Dealership User', 'Manager', 1, 1, NULL, 'Active', '2013-08-29 08:22:18', NULL, 0),
(10, 4, NULL, NULL, NULL, NULL, 8, 10, 'shanek@hyundai.co.za', '82722ff87287a4184a8b3d1e8b7155939606d82a', 'df12fa193696c209067f7548f4d5c6ff15617689', 'Shane', 'Kruger', '7001012020009', '1970-01-01', '+27827778995', NULL, 'Dealership User', 'Manager', 1, 1, NULL, 'Active', '2013-08-29 08:22:18', NULL, 0),
(11, 5, NULL, NULL, NULL, NULL, 10, 11, 'bstephenson@cargomotors.co.za', '2284a7ac6af6615a961095a812eb0efa3e9910fd', '7823d54cc1b66d59f3e0e80d5ecfea0fde98ebc9', 'Byron', 'Stephenson', '7001012020008', '1970-01-01', '+27826039258', NULL, 'Dealership User', 'Manager', 1, 1, NULL, 'Active', '2013-08-29 08:22:18', NULL, 0),
(12, 1, NULL, NULL, NULL, NULL, 1, 12, 'admin@admin.co.za', 'eb7642f6809d21d2af42aea57e210961fc6e8f5d', 'c754843ca7124cad1940f3c1cbb1ccc3271a337c', 'Full', 'Administrator', '7001012020008', '1970-01-01', '+27826039258', NULL, 'Dealership User', 'Manager', 1, 1, NULL, 'Active', '2013-08-29 08:22:18', NULL, 0);